Youcanusea_________filter to limit your query results based on one or more conditions.
Choose an answer
Tap an option to check your answer.
Correct answer: WHERE.
Why this is the answer
The WHERE clause is used to filter records based on specified conditions, returning only the rows that satisfy those conditions. For example, SELECT FROM sales WHERE productcategory = 'Electronics' would retrieve all sales records only for products in the 'Electronics' category. SELECT is incorrect because it is used to specify which columns you want to retrieve from a table, not to filter rows based on conditions. For example, SELECT productname, price FROM products would return only the product names and prices, but for all products.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed