Browse All Questions

What does UNION ALL do differently from UNION?

SQL Data AnalystEasy

Try Now

What does MIN(price) return?

SQL Data AnalystEasy

Try Now

What is the correct SQL clause execution order for a standard SELECT query?

SQL Data AnalystEasy

Try Now

Which SQL keyword retrieves all columns from a table?

SQL Data AnalystEasy

Try Now

What does WHERE salary BETWEEN 50000 AND 80000 include?

SQL Data AnalystEasy

Try Now

What does a foreign key enforce in a relational database?

SQL Data AnalystEasy

Try Now

What does SUM(quantity) return in a GROUP BY query per group?

SQL Data AnalystEasy

Try Now

What does the NOT operator do when combined with IN?

SQL Data AnalystEasy

Try Now

Which SQL clause specifies the table to query data from?

SQL Data AnalystEasy

Try Now

What does UNION do when combining two SELECT statements?

SQL Data AnalystEasy

Try Now

What is a primary key in a relational database?

SQL Data AnalystEasy

Try Now

What does WHERE name LIKE ‘A%’ return?

SQL Data AnalystEasy

Try Now

What does the alias AS keyword do in SQL?

SQL Data AnalystEasy

Try Now

Which function returns the highest value in a column?

SQL Data AnalystEasy

Try Now

What is the result of COUNT(*) on a table with 5 rows where 2 rows have NULL in a column?

SQL Data AnalystEasy

Try Now

What does the IN operator do in a WHERE clause?

SQL Data AnalystEasy

Try Now

Which SQL statement is used to retrieve data from a table?

SQL Data AnalystEasy

Try Now

What does a LEFT JOIN return that an INNER JOIN does not?

SQL Data AnalystEasy

Try Now