SQL Basics
This SQL command is used to retrieve data from a database.
Answer: What is SELECT?
This type of join returns records that have matching values in both tables.
Answer: What is an INNER JOIN?
This function returns the maximum value in a set.
Answer: What is MAX()?
This SQL command is used to add new rows to a table.
Answer: What is INSERT?
This command is used to create a new table in a database.
Answer: What is CREATE TABLE?
This keyword is used to eliminate duplicate records in a SELECT query.
Answer: What is DISTINCT?
This type of join returns all records from the left table and the matched records from the right table.
Answer: What is a LEFT JOIN?
This function returns the minimum value in a set.
Answer: What is MIN()?
This SQL clause is used to limit the number of rows returned by a query.
Answer: What is LIMIT?
This command is used to remove a table and all its data from a database.
Answer: What is DROP TABLE?
This clause is used to filter records based on a specified condition.
Answer: What is WHERE?
This type of join returns all records from the right table and the matched records from the left table.
Answer: What is a RIGHT JOIN?
This function returns the sum of a numeric column.
Answer: What is SUM()?
This SQL clause is used to change existing data within a table.
Answer: What is UPDATE?
This command is used to change the structure of an existing table.
Answer: What is ALTER TABLE?
This function is used to count the number of rows in a table.
Answer: What is COUNT()?
This type of join returns all records when there is a match in either left or right table.
Answer: What is a FULL JOIN?
This function returns the average value of a numeric column.
Answer: What is AVG()?
This SQL command removes all records from a table but does not delete the table itself.
Answer: What is TRUNCATE?
This command is used to remove all records from a table but keeps the table structure for future use.
Answer: What is DELETE?
This clause is used to sort the result set of a query.
Answer: What is ORDER BY?
This keyword is used to combine rows from two or more tables based on a related column between them.
Answer: What is JOIN?
This clause is used to group rows that have the same values in specified columns.
Answer: What is GROUP BY?
This keyword is used to ensure that all values in a column are unique and not null.
Answer: What is PRIMARY KEY?
This command is used to retrieve data from multiple tables in a single query.
Answer: What is JOIN?