Tutorial Gateway

Python SQL Select Statement

by

In this article, we will show you, How to write a SQL Select Statement in the Python Programming language and how to extract the records from a Table. 

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 Select statement example, let me show you the data that we are going to use.

Python SQL Select Statement Example 1

Python SQL Select statement Example 1

In this example, we will show you, how to use the select statement to select records from a SQL Table

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

cursor = conn.cursor()
cursor.execute('SELECT * FROM CustomerSale')

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

OUTPUT

Python SQL Select Statement Example 2

ANALYSIS

First, we imported or selected data from Customer Sales table present in SQL Tutorial Database

cursor = cursor.execute('SELECT * FROM CustomerSale')

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

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

Python SQL Select statement Example 2

Instead of selecting all the unnecessary columns (using * ), you can select the required columns.

This example selects the Employee Id, Occupation, Yearly Income and Sales columns from the Customer Sales table.

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

cursor = conn.cursor()
cursor.execute('SELECT EmpID, Occupation, YearlyIncome, Sales FROM CustomerSale')

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

OUTPUT

Python SQL Select Statement Example 3

SQL Select in Python Example 3

In Python, the cursor has many functions. You can use these functions to alter the result provided by the select statement.

Python SQL Select Statement Example 4

For example, fetchone function fetches only one row or record from a table

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

cursor = conn.cursor()
cursor.execute('SELECT * FROM CustomerSale')
result = cursor.fetchone()
print(result)

OUTPUT

Python SQL Select Statement Example 5