The distinct clause is helpful when there is a need of avoiding the duplicate values present in any specific columns/table. When we use distinct keywords only the unique values are fetched. In this example, we are going to display the different grades scored by students from the "student table".
Example:
import Sqlite3
connection = sqlite3.connect (''Academy.db'')
cursor = connection.cursor ( )
cursor.execute ("SELECT DISTINCT(Grade) FROM student")
result = cursor.fetchall ( )
print (result)
Output:
[('B',), ('A',), ('C',), ('D',)]

The cursor object is created by calling the cursor() method of connection. The cursor is used to traverse the records from the result set. We can define a SQL command with a triple quoted string in Python. The reason behind the triple quotes is sometimes the values in the table might contain single or double quotes.

import sqlite3
connection = sqlite3.connect (''Academy.db'')
cursor = connection.cursor ( )
cursor.execute ("SELECT *FROM student")
print("fetching first 3 records:")
result = cursor.fetchmany(3)
print(* result, sep= '\n")
Output:
fetching first 3 records
(1, 'Akshay', 'B', 'M',87.8, '2001-1212')
(2, 'Aravind', 'A', 'M', 92.5, '2000-08-17')
(3, 'Basker', 'C', 'M', 95.2, '1999-05-17')

Display specified number of records is done by using fetchmany( ). This method returns the next number of rows(n) of the result set.
Example:
import sqlite3
connection = sqlite3.connect (''Academy.db'')
cursor = connection.cursor( )
cursor.execute ("SELECT *FROM student")
print("fetching first 3 records:")
result= cursor.fetchmany(3)
print(result)
Output:
fetching first 3 records:
[(1, 'Akshay', 'B', 'M',87.8, '2001-1212'),
(2, 'Aravind', 'A', 'M', 92.5, '2000-08-17'),
(3, 'Basker', 'C', 'M', 75.2, '1999-05-17')]

Using the while loop and fetch one method we can display all the records from a table one by one.
Example:
import sqlite3
connection = sqlite3.connect (''Academy.db'')
cursor = connection.cursor ( )
cursor.execr,rte ("SELECT *FROM student")
print("fetching all records one by one :")
print(result)
result = cursor.fetchone( )
Output:
fetching all records one by one:
(1, 'Akshay', 'B', 'M', 87.8, '2001-1212')
(2, 'Aravind', 'B', 'M', 92.5, '2000-08-17')
(3, 'BASKER', 'C', 'M', 95.2, '1999-05-17')
(4, 'SAJINI', 'A', 'F', 95.6, '2002-11-01')
(5, 'VARUN', 'B', 'M', 80.6, '2002-03-14')

The fenchone( ) method returns the next rows of a query result set or none in case there is no row left.
Example:
import sqlite3
connection = sqlite3.connect (''Academy.db'')
cursor = connection.cursor ( )
cursor.execr,rte ("SELECT *FROM student")
print("\n fetchone:")
res = cursor.fetchone( )
print(res)
Output:
fetchone:
(1, 'Akshay', 'B', 'M',87.8, '2001-1212')

The fetchall ( ) method is used to fetch all rows from the database table.
Example:
import Sqlite3
connection = sqlite3.connect (''Academy.db'')
cursor = connection.cursor( )
cursor.execute ("SELECT * FROM student")
print("fetchalI:")
result = cursor.fetchall ( )
for r in result:
print (r)
Output:
fetchall:
(1, 'Akshay', 'B', 'M', 87.8, '2001-1212')
(2, 'Aravind', 'B', 'M', 92.5, '2000-08-17')
(3, 'Basker', 'C', 'M', 95.2, '1999-05-17')
(4, 'SAJINI', 'A', 'F', 95.6, '2002-11-01')
(5, 'VARUN', 'B', 'M', 80.6, '2002-03-14')

A condition to be made to the database through Python Sqlite3.
#Python code to demonstrate table creation and insertions with SQL.
#importing module.
import sqlite3
#connecting to the database.
connection - sqlite3. connect ("Academy.db")
#cursor
Cursor = Connection. Cursor( )
A database with the name "Academy" would be created. It's similar to the SQL command "CREATE DATABASE Academy;" to the SQL Server. "Sqlite3. connect ('Academy. db')" is again used some program, "connect" command just open the already created database.

(i) DISTINCT
(ii) WHERE
(iii) GROUP BY
(iv) ORDER BY.
(v) HAVING

(i) "SELECT" is the most commonly used statement in SQL.
(ii) The SELECT Statement in SQL is used to retrieve or fetch data from a table in a database.
(iii) The syntax for using this statement is "Select * from table_name" and all the table data can be fetched in an object in the form of list of lists. List the classes used in

(I) COUNT ( ) function returns the number of rows in a table.
(ii) AVG ( ) function retrieves the average of a selected column of rows in a table.
(iii) SUM ( ) function retrieves the sum of a selected column of rows in a table.
(iv) MAX( ) function returns the largest value of the selected column.
(v) MIN( ) function returns the smallest value of the selected column.

Aggregate functions are used to do operations from the values of the column and a single value is returned.
(i) COUNT ( )
(ii) AVG ( )
(iii) SUM ( )
(iv) MAX ( )
(v) MIN ( )

# Python code to demonstrate table creation and insertions with SQL
# importing module
import sqlite3
# connecting to the database
connection = sqlite3.connect ("Academy.db")
# cursor
cursor = connection.cursor ( )

Step 1: Import sqlite3
Step 2: Create a connection using connect o method and pass the name of the database File
Step 3: Set the cursor object cursor = connection. cursor ( )

(i) The SELECT statement can be used along with GROUP BY clause.
(ii) The GROUP BY clause groups records into summary rows. It returns one records for each group.
(iii) It is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result -set by one or more columns.