Multiple choice

What will be the SQL query to retrieve the sp and cp of all products whose item (name) is not entered?

Table:Product(id,item,sp,cp)

  1. Select sp,cp from product where item is NULL;

  2. Select sp,cp from product where item = NULL;

  3. Select sp,cp from product where item = 0;

  4. All of the above

  5. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Output: to retrieve the sp,cp of all products Condition: whose item (name) is not entered implies null entries in item column. Option 1 is the correct answer.

Keep practicing — related questions