Tutorial Gateway

Python SQL Order By

by

In this article, we will show you, How to write a SQL Order By in the Python Programming language and how to sort the Table records with an example. 

TIP: Please refer Connect Python to SQL Server article to understand the steps involved in establishing a connection.

Before we get into the Python SQL Order By example, let me show you the data that we are going to use.

Python SQL Order by Example 1

Python SQL Order By Example 1

In this example, we will show you, how to use the Order By Clause to sort the Data in Ascending Order.

Here, ASC is the keyword for Ascending order. By default, Order by sort data in ascending order so, it is optional to include ASC keyword. 

# Python SQL Order By Example
import pyodbc
dbConn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                      "Server=PRASAD;"
                      "Database=SQL Tutorial;"
                      "Trusted_Connection=yes;")

OrderCursor = dbConn.cursor()
OrderCursor.execute('SELECT * FROM CustomerSale ORDER BY  YearlyIncome')

for row in OrderCursor:
    print('row = %r' % (row,))

OUTPUT

Python SQL Order by Example 2

ANALYSIS

First, we selected data from Customer Sales table present in SQL Tutorial Database. This data is sorted by Yearly Income in Ascending order.

OrderCursor.execute('SELECT * FROM CustomerSale ORDER BY YearlyIncome')

Next, we used the For loop to iterate each and every row present in the Order Cursor. Within the For Loop, we used the print statement to print rows.

for row in OrderCursor: 
   print('row = %r' % (row,))

Python SQL Order By Example 2

This example sorts the Customer table in descending order using the Yearly Income column. 

# Python SQL Order By Example
import pyodbc
dbConn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                      "Server=PRASAD;"
                      "Database=SQL Tutorial;"
                      "Trusted_Connection=yes;")

OrderCursor = dbConn.cursor()
OrderCursor.execute('SELECT * FROM CustomerSale ORDER BY YearlyIncome DESC')

for row in OrderCursor:
    print('row = %r' % (row,))

OUTPUT

Python SQL Order by Example 3