Asked in PPSC, FPSC and other one-paper exams (compiled from unofficial resources).
Database Management SystemSQL Basics
Which SQL query would you use to find employees earning more than $5000 a month?
- A.SELECT * FROM employees WHERE salary = 5000;
- B.SELECT * FROM employees WHERE salary < 5000;
- C.SELECT * FROM employees WHERE salary > 5000;Correct answer
- D.SELECT * FROM employees WHERE salary >= 5000;
Timed quizzes, instant results, track your progress — free
Practice these MCQs in the appQuick fact: The correct SQL query to find employees earning more than $5000 a month is SELECT * FROM employees WHERE salary > 5000;