Question
Which SQL operator is used to search for a pattern in a
column?Solution
LIKE allows pattern matching using wildcards (% for any sequence of characters, _ for a single character).
Which SQL keyword prevents duplicate rows in result?
Which of the following SQL constructs avoids returning duplicate rows?
What is the output of this SQL snippet if the price column contains NULL values?
SELECT SUM(price) FROM products;
Which SQL constraint ensures that a column’s values are unique across the table?
Which clause is used to sort query results in SQL?
Which SQL command is used to modify existing records in a table?
What is the primary purpose of a `SEQUENCE` in SQL?
What is an SQL `VIEW`?
Which SQL function returns the largest value in a column?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
