Here is the code

First, we connect to the database

import sqlite3

# We create the connection
con = sqlite3.connect('example.db')

# We create a cursor to perform our requests
cur = con.cursor()

We connect to the database or create if doesn't exist

Second, we create our table and fill it up with dummy data

# Create a table
cur.execute("CREATE TABLE revenues (date text, amount float, source text)")

# Insert multiple entries in the database
entries = [
    ('2020-11-31', 12349.2, 'shopify'),
    ('2020-12-31', 14523.2, 'shopify'),
    ('2021-01-31', 18029.4, 'shopify'),
    ('2021-02-29', 51023.3, 'shopify'),
    ('2021-03-31', 94400.3, 'shopify'),
]
cur.executemany("INSERT INTO revenues VALUES (?,?,?)", entries)

# Save (commit) the changes
con.commit()

We create the connection, insert the data and commit the changes

Third, we retrieve data

One entry

cur.execute("select * from revenues").fetchone()

All entries

cur.execute("select * from revenues").fetchall()

All entries that match the condition

cur.execute("select * from revenues where amount >= 14000").fetchall()

Here you are! You now know how to retrieve data from an SQLite3 Database.

You might be interested in

How to install SQLite3 in Python

Learn how to install SQLite 3 in Python

The Python You NeedBastien

How to create an SQLite3 Database using Python

Learn how to create an SQLite3 database using Python.

The Python You NeedBastien

How to connect to an SQLite3 database using Python

Learn how to connect to an SQLite3 database using python.

The Python You NeedBastien

How to add a new table in SQLite3 using Python

Learn how to add a new table in SQLite3 using Python.

The Python You NeedBastien

How to add an entry to an SQLite database

Learn how to add an entry to an SQLite database using the execute() method.

The Python You NeedBastien

How to retrieve data entries from SQLite3 using Python

How to add a new table in SQLite3 using Python

How to connect to an SQLite3 database using Python

How to create an SQLite3 Database using Python

How to READ a Pandas DataFrame from an SQLite Database using Python

Are you looking for something else?