Multiple choice technology databases

Use these data for the following Questions EMPNO ENAME SAL E100 John 3250 E200 Praveen 2000 E300 Mahesh E400 Prasanth 5500 E500 Vikram 6650 Select count (sal) from Emp will retrieve

  1. 1

  2. 0

  3. 3

  4. 4

  5. None of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The COUNT(column) function counts only the non-null values in the specified column. Since Mahesh has a null value for SAL, only the other four employees (John, Praveen, Prasanth, and Vikram) have valid numeric values, resulting in a count of 4.

Keep practicing — related questions