edited by
761 views
5 votes
5 votes

A relational table Employee (ENo, EName, Dept) has $88$ number of tuples. What will be the result of following SQL statement?

SELECT COUNT (ENo) FROM Employee WHERE ENo NOT IN (NULL);

  1. $88$
  2. $44$
  3. $0$
  4. $87$

edited by

1 Answer

Best answer
10 votes
10 votes
Where E_no not in NULL - the predicate evaluates to unknown. so no rows will be printed.
selected by

Related questions

1 votes
1 votes
1 answer
1
Isha Gupta asked Jun 12, 2016
4,039 views
which operation is used to extract specific columns from a table?
3 votes
3 votes
1 answer
2
Rahul Jain25 asked Oct 4, 2016
4,102 views