- Tutorials
- Courses
Data Structure
Java
Python
HTML
Interview Preparation
SQL Query-Based Questions Quiz
Query-based questions are fundamental to extracting, filtering, and manipulating data within databases using SQL. In this quiz, you'll encounter a variety of SQL queries, covering topics such as SELECT statements, WHERE clauses, JOIN operations, GROUP BY clauses, and more.
Last Updated :
Discuss
Comments
Question 1
Write an SQL query to retrieve all columns from the "employees" table.
SELECT * FROM employees;
SELECT ALL employees;
SELECT COLUMN employees;
SELECT employees;
Question 2
Write an SQL query to retrieve distinct values from the "department" column of the "employees" table.
SELECT DISTINCT department FROM employees;
SELECT UNIQUE department FROM employees;
SELECT department FROM employees DISTINCT;
SELECT department DISTINCT FROM employees;
Question 3
Write an SQL query to retrieve the names of employees whose salary is greater than 50000.
SELECT name FROM employees HAVING salary > 50000;
SELECT name FROM employees WHERE salary > 50000;
SELECT name FROM employees WHERE salary > '50000';
SELECT name FROM employees GROUP BY salary HAVING salary > 50000;
Question 4
Write an SQL query to retrieve the number of employees in each department.
SELECT COUNT() FROM employees ORDER BY department;
SELECT COUNT(department) FROM employees GROUP BY department;
SELECT COUNT(*) FROM employees GROUP BY department;
SELECT COUNT(*) AS employees_count, department FROM employees;
Question 5
Write an SQL query to retrieve the highest salary from the "employees" table.
SELECT TOP 1 salary FROM employees ORDER BY salary DESC;
SELECT salary FROM employees WHERE salary = MAX(salary);
SELECT salary FROM employees ORDER BY salary DESC LIMIT 1;
SELECT MAX(salary) FROM employees;
Question 6
Write an SQL query to retrieve the names of employees whose names start with 'A'.
SELECT name FROM employees WHERE name LIKE 'A%';
SELECT name FROM employees WHERE name = 'A%';
SELECT name FROM employees WHERE name LIKE '%A';
SELECT name FROM employees WHERE name = '%A%';
Question 7
Write an SQL query to retrieve the average salary of all employees.
SELECT AVERAGE(salary) FROM employees;
SELECT AVG(salary) FROM employees;
SELECT SUM(salary) / COUNT(salary) FROM employees;
SELECT MEAN(salary) FROM employees;
Question 8
Write an SQL query to retrieve the names of employees who joined in the year 2021.
SELECT name FROM employees WHERE JOIN_YEAR = 2021;
SELECT name FROM employees WHERE JOIN_DATE LIKE '2021%';
SELECT name FROM employees WHERE YEAR(JOIN_DATE) = 2021;
SELECT name FROM employees WHERE JOIN_DATE BETWEEN '2021-01-01' AND '2021-12-31';
Question 9
Write an SQL query to retrieve the names of employees who belong to the 'Sales' department and have a salary greater than 60000.
SELECT name FROM employees WHERE department = 'Sales' AND salary > 60000;
SELECT name FROM employees WHERE department = 'Sales' OR salary > 60000;
SELECT name FROM employees WHERE department = 'Sales' HAVING salary > 60000;
SELECT name FROM employees GROUP BY department, salary HAVING department = 'Sales' AND salary > 60000;
Question 10
Write an SQL query to retrieve the names of employees who have 'Manager' in their job titles.
SELECT name FROM employees WHERE job_title = 'Manager';
SELECT name FROM employees WHERE job_title LIKE '%Manager%';
SELECT name FROM employees WHERE job_title = '%Manager%';
SELECT name FROM employees WHERE job_title LIKE 'Manager';
There are 10 questions to complete.
Take a part in the ongoing discussion
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy