Questions and Answers
Which statement allows the combination of Insert and Update in one statement?
MERGE
In SQL, which clause is used to indicate the conditions under which a row will be included in the result?
WHERE
Which type of SQL statement is used for queries on single or multiple tables?
SELECT
Which SQL clause indicates categorization of results?
Signup and view all the answers
In SQL, which type of statement is used to manipulate the database by selecting data?
Signup and view all the answers
In SQL, what does the HAVING clause do?
Signup and view all the answers
What is a scalar aggregate in the context of SQL?
Signup and view all the answers
What does the LIKE operator in SQL allow you to do?
Signup and view all the answers
When using the GROUP BY clause in SQL, what do you include in the SELECT clause?
Signup and view all the answers
What does an alias represent in SQL?
Signup and view all the answers