Multiple choice

Employee table has salary field in this case if we give the query : select * from employee where sal<2000 and sal>9000 which will yield result as _______.

  1. rows with Sal<2000 and Salary>9000 will be displayed.

  2. all the rows are displayed with any one of the condition satisfied.

  3. no rows will be selected.

  4. between sal 2000 and 9000 will be displayed.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The query uses AND to combine two contradictory conditions: sal<2000 AND sal>9000. Since a value cannot simultaneously be less than 2000 AND greater than 9000, no rows will satisfy both conditions, resulting in an empty result set.

Keep practicing — related questions