Assuem the department table has 10 rows. What would be the result of the following query

Select * from Department where 1=2;

In the where clause there is no restriction that the condition needs to contain a column from the table involved in the query. Since the condition 1=2 failed it will return 0 rows.