Browse All Questions

Which wildcard character matches any sequence of characters in a LIKE pattern?

SQL FundamentalsEasy

Try Now

What keyword is used to give a column or table a temporary name in a query?

SQL FundamentalsEasy

Try Now

What does MAX(score) return?

SQL FundamentalsEasy

Try Now

How do you check if a column value is NULL in SQL?

SQL FundamentalsEasy

Try Now

Which type of JOIN returns only rows where there is a match in both tables?

SQL FundamentalsEasy

Try Now

What happens if you run DELETE FROM employees without a WHERE clause?

SQL FundamentalsEasy

Try Now

Which statement modifies existing records in a table?

SQL FundamentalsEasy

Try Now

Which SQL statement is used to add new rows to a table?

SQL FundamentalsEasy

Try Now

What is the difference between WHERE and HAVING?

SQL FundamentalsEasy

Try Now

Which clause is used to group rows sharing a property so aggregate functions can be applied?

SQL FundamentalsEasy

Try Now

What does MIN(price) return in a query?

SQL FundamentalsEasy

Try Now

Which aggregate function calculates the arithmetic mean of a column?

SQL FundamentalsEasy

Try Now

What does SUM(salary) return when used in a query?

SQL FundamentalsEasy

Try Now

Which aggregate function returns the number of rows matching a condition?

SQL FundamentalsEasy

Try Now

What does the DISTINCT keyword do in a SELECT statement?

SQL FundamentalsEasy

Try Now

Which clause restricts the number of rows returned by a query?

SQL FundamentalsEasy

Try Now

What does ORDER BY DESC do?

SQL FundamentalsEasy

Try Now

Which clause is used to filter rows returned by a SELECT statement?

SQL FundamentalsEasy

Try Now