Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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'
on 11/11/2012 | Category:
Sql Server Interview questions
| Views: 2839 |
Select from following answers:
zero (no) rows
Normally NULL value will be omitted when we select query based on column. Since empstaus of 'Kevin' is NULL, it will not be considered even though it is not 'A'. So It will return only one row that is of employee 'Kumar'.
Show Correct Answer
Many Interviews |
< Previous :
Page_Init event occurs only when the first time th ...
Next > :
What is the value of variable "i" at the ...
Comments or Responses
on: 11/15/2012 |
excellent nagasundar can you help me with these kind of scenario queries and send me to the mail id email@example.com
on: 11/22/2012 |
thank you so much for helping to gain a more knowledge
on: 1/13/2013 |
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 firstname.lastname@example.org
Login to post response
More Interview Questions by Nagasundar_Tn
What is the value of variable "i" at the end of the function ...
We have two tables one is employee and another one is City. Employee t ...
Write a code snippet for Left outer join using LINQ?
Latest Interview Questions
What is geolocation in html5 ? give a real time example which you had ...
Suggest some methods of overcoming Interface mismatch
Suggest some actions to be taken when a interface mismatch got identif ...
What are the categories of Interface mismatch?
How to identify Interface Mismatch?
Why a interface mismatch happens OR What hinder the components to work ...
What are some of the reasons that influence analysis for the Buy decis ...
What is the major reason(s) for the usage of commercial-off-the-shelf ...