SQL Fundamentals

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

SQL FundamentalsEasy

Try Now

What does WHERE age BETWEEN 18 AND 30 return?

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

Which condition correctly filters out NULL values?

SQL FundamentalsEasy

Try Now

Which aggregate function calculates the arithmetic mean of a column?

SQL FundamentalsEasy

Try Now

What is a primary key?

SQL FundamentalsEasy

Try Now

What does MIN(price) return in a query?

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 is the difference between WHERE and HAVING?

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

Which statement modifies existing records in a table?

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now