Basic Sql Flashcards
What SQL command is used to retrieve data from a database?
SELECT
What clause is used to filter results in a SELECT query?
WHERE
How do you select all columns from a table named ‘users’?
SELECT * FROM users;
What SQL keyword is used to insert a new row into a table?
INSERT INTO
How do you insert a new row into a table named ‘users’ with columns ‘name’ and ‘age’?
INSERT INTO users (name
What SQL statement is used to update existing records in a table?
UPDATE
How do you update the age of a user named ‘John’ to 26 in the ‘users’ table?
UPDATE users SET age = 26 WHERE name = ‘John’;
What SQL command deletes records from a table?
DELETE
How do you delete a user named ‘John’ from the ‘users’ table?
DELETE FROM users WHERE name = ‘John’;
What SQL clause is used to sort query results?
ORDER BY
How do you sort the ‘users’ table by ‘age’ in descending order?
SELECT * FROM users ORDER BY age DESC;
What SQL clause groups rows that have the same values?
GROUP BY
What SQL function counts the number of rows in a table?
COUNT()
How do you count the number of users in the ‘users’ table?
SELECT COUNT(*) FROM users;
What SQL clause is used with aggregate functions to filter groups?
HAVING
What SQL keyword is used to remove duplicate rows in a result set?
DISTINCT
How do you select unique values from the ‘city’ column in the ‘users’ table?
SELECT DISTINCT city FROM users;
What SQL statement creates a new table?
CREATE TABLE
How do you create a table named ‘employees’ with ‘id’ as an integer and ‘name’ as text?
CREATE TABLE employees (id INT, name TEXT);
What SQL statement deletes an entire table?
DROP TABLE
What SQL command is used to add a new column to an existing table?
ALTER TABLE
How do you add a column named ‘email’ of type VARCHAR(255) to the ‘users’ table?
ALTER TABLE users ADD COLUMN email VARCHAR(255);
