Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
    The SQL statement
    SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
    prints

    2. A.

     10
    B.

     9
    C.

     5
    D.

     0

    View Answer

    Workspace

    View Answer

    Answer : Option D

    Explanation :

    This query counts the number of employees who gets more than the maximum salary.

Write your comments here:

Be The First To Comment