Program: Display the records in descending order using python script
import mysqldb
db = mysqldb.connect ("local host", "user", "123", "organization")
cursor = db.cursor()
cursor.execute ("SELECT *FROM Employee ORDER BY Name DESC")
result = cursor.fetchall()
for row in results:
ENO = row[0], EmpName = row[1], EmpDept = row[2]
print ENO, EmpName, EmpDept
db.close()

Db: Organization.db
Table name: Employee
Column: Eno, EmpName, Esal, Dept
Program:
import mysqldb
db = mysqldb.connect("localhost, "user", "123", "organization")
cursor= db.cursor()
Cursor.execute ("SELECT *FROM Employee")
results = cursor.fetchall()
for row in results:
Eno = row[0], EmpName = row[1], EmpDept = row[2]
print Eno, EmpName, EmpDept
db.close()

The WHERE clause is used to extract only those records that fulfill a specified condition. In this example we are going to display the different grades scored by male students from "student table.
import sqlite3
connection = sqlite3.connect ("Academy.db")
cursor = connection.cursor()
cursor.execute ("SELECT DISTINCT (Grade) FROM student where gender = "M")
result = cursor.fetchall()
print(* result, sep ="\n")
Output:
('B,')
('A,')
('C,')
('D,')

fetchone() fetchmany() Returns the next row of a query result set or none in case there is no row left.
Using while loop and fetchone() method we can display all the records from a table one by one. Returns the next number of rows(n) of the result set.
Displaying specified number of records is done by using fetchmany():  

(i) SQLite is a simple relational database system, which saves its data in regular data files or even in the internal memory of the computer.
(ii) It is designed to be embedded in applications, instead of using a separate database server program such as MySQL or Oracle.
Advantages:
SQLite is fast, rigorously tested, and flexible, making it easier to work.
Python has a native library for SQLite.