Question

How will you use order by clause in SQL. Explain with sample program?

Answer 1

The ORDER BY Clause can be used along with the SELECT statement to sort the data of specific fields in an ordered way. It is used to sort the result-set in ascending or descending order. In this example name and Rollno of the students are displayed in alphabetical order of names.

Example

import sqlite3

connection= sqlite3.connect(“Academy.db”)

cursor = connection.cursor( ) 

cursor.execute(“SELECT Rollno,sname FROM student Order BY sname”)

result = cursor.fetchall( )

print(*result,sep= ” \n”)

OUTPUT

(1, ‘Akshay’)

(2, ‘Aravind’)

(3, ‘BASKAR’)

(6, ‘PRIYA’)

(4, ‘SAJINI’)

(7, ‘TARUN’)

(5, ‘VARUN’)