Junior — Middle
Do you have experience in writing and executing SQL queries?
sobes.tech AI
Answer from AI
Yes, I have experience in writing and executing SQL queries. For example, to select data from a table, you can use a query:
SELECT id, name, email FROM users WHERE active = 1;
In Python, libraries such as sqlite3 or psycopg2 for PostgreSQL are often used to execute such queries. An example using sqlite3:
import sqlite3
conn = sqlite3.connect('example.db')
cursor = conn.cursor()
cursor.execute('SELECT id, name FROM users WHERE active = 1')
rows = cursor.fetchall()
for row in rows:
print(row)
conn.close()