What will be the output of below query?

Select * from employee_master where 1 <> 1;

If employee_master have only 25 rows.

 Posted by vishalneeraj-24503 on 12/6/2013 | Category: Sql Server Interview questions | Views: 3793 | Points: 40

It will Not return any record as condition is false.Because select query filters rows based on where clause we pass in select query.If condition is true it returns rows otherwise does not return any record.

Here 1<>1 means condition is false.That's why it will not return any row.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response