Querying Data with SELECT

SELECT retrieves data from tables. Execute it through your cursor and fetch the results.

cursor.execute("SELECT name, age FROM users")
rows = cursor.fetchall()

for row in rows:
    print(row[0], row[1])  # name, age

fetchall() returns all rows as a list of tuples. For large results, use fetchone() to get rows one at a time.

Add conditions with WHERE:

cursor.execute("SELECT name FROM users WHERE age > 30")

Order results:

cursor.execute("SELECT name FROM users ORDER BY age DESC")

Limit results:

cursor.execute("SELECT name FROM users LIMIT 10")

You can combine these clauses to build complex queries.

I explain SELECT patterns in my SQL with Python course.