Question

Read the following details Based on that write a python script to display records in descending order of

Eno

database name:- organization.db

Table name:- Employee

Columns in the table:- Eno, EmpName, Esal, Dept

Answer 1

Contents of Table: Employee

Eno	EmpName	Esal	Dept
1001	Aswin	28000	IT
1003	Helena	32000	Accounts
1005	Hycinth	41000	IT

Coding:

import sqlite3
connection = sqlite3 . connect
(“organization, db”)
cursor = connection, cursor ()
cursor, execute (“SELECT *
FROM Employee ORDER BY Eno DESC”)
result = cursor, fetchall ()
print (“Department wise
Employee List in descending order:”)
for i in result:
print(i)
connection.close()

Output:

Department wise Employee List in descending order:
(1005,’Hycinth’,41000,’IT’)
(1003,’Helena’,32000, ‘Accounts’)
(1001,’Aswin’,28000,’IT’)