Which of the following SQL operators is used to compare two values for equality?
Which SQL operator is used to check if a value is not equal to another value?
1 Crore+ students have signed up on EduRev. Have you? Download the App |
Which SQL operator is used to compare two values to check if one is greater than the other?
Which SQL operator is used to check if a value falls within a specified range?
Which SQL operator is used to check if a value matches a specified pattern?
Consider the following SQL query:
SELECT * FROM employees WHERE salary > 50000;
What would be the output of the above query?
Consider the following SQL query:
SELECT * FROM customers WHERE country = 'USA';
What would be the output of the above query?
Consider the following SQL query:
SELECT * FROM products WHERE category IN ('Electronics', 'Appliances');
Consider the following SQL query:
SELECT * FROM orders WHERE order_date BETWEEN '2022-01-01' AND '2022-12-31';
What would be the output of the above query?
Consider the following SQL query:
SELECT * FROM products WHERE product_name LIKE 'Ap%';
Consider the following SQL query:
SELECT * FROM employees WHERE salary BETWEEN 30000 AND 40000;
What would be the output of the above query?
Consider the following SQL query:
SELECT * FROM customers WHERE country <> 'USA' AND city = 'London';
What would be the output of the above query?
Consider the following SQL query:
SELECT * FROM orders WHERE order_date > '2022-01-01' ORDER BY order_date DESC;
What would be the output of the above query?
Consider the following SQL query:
SELECT * FROM products WHERE product_name LIKE '%book%';
What would be the output of the above query?
Consider the following SQL query:
SELECT * FROM orders WHERE order_id IN (SELECT order_id FROM order_items WHERE quantity > 10);