1.

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

Answer»

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’)


Discussion

No Comment Found

Related InterviewSolutions