I have the following EmployeeMaster table in Test database.

empID empName empStatus
1 Naga A
2 Sundar A
3 Siva A
4 Shankar A
5 Kevin NULL
6 Kumar I


In Empstatus column we are having four Active employees,one inactive employee and one employee without any status that is NULL.

If I run the following query, how many rows will be returned by SQL Server?

select * from EmployeeMaster where empStatus <> 'A'

 Posted by Nagasundar_Tn on 11/11/2012 | Category: Sql Server Interview questions | Views: 4328 | Points: 40
Select from following answers:
  1. one row
  2. two rows
  3. four rows
  4. zero (no) rows
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: balajirnaukri-12656 on: 11/15/2012 | Points: 10
excellent nagasundar can you help me with these kind of scenario queries and send me to the mail id balajirnaukri@gmail.com
Posted by: aswinialuri-19361 on: 11/22/2012 | Points: 10
thank you so much for helping to gain a more knowledge
Posted by: Shanmessage on: 1/13/2013 | Points: 10
Dear NagaSundar,

Dera NagaSundar,

I have go through your blog nice material. Thanks


Day After Tomorrow i have a interview please send sql interview question i'm having 4 years of experience in software field.

my mail id is shanmessage@gmail.com

Login to post response