engineering computer science MCQ #694

What is the result of the SQL query: SELECT COUNT(*) FROM employees WHERE salary > 50000?

engineering computer science MCQ #694

  1. Question 1

    Q1. What is the result of the SQL query: SELECT COUNT(*) FROM employees WHERE salary > 50000?

    • A) Number of employees with salary less than 50000
    • B) Number of employees with salary greater than 50000
    • C) Average salary of employees
    • D) Total salary of employees

    Answer: Number of employees with salary greater than 50000

    Explanation: The COUNT(*) function counts the number of rows in the employees table where the salary is greater than 50000.