what is the out put of below queries? a. select * from Emp where null = nul

what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;

Question Posted / jawahar

13 Answers
24919 Views
Patni, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the out put of below queries? a. select * from Emp where null = null; b. select * ..

Answer / poonam

First Query : will return all columns name without any data.
Second Query :will display all the records which are available in the table.bez Select* from emp where 1=1; the condition is true.

Is This Answer Correct ?

0 Yes

0 No

what is the out put of below queries? a. select * from Emp where null = null; b. select * ..

Answer / nitin yadav(nitin.yadav.india@

u can not compare two nulls

null means nothing.so
ANS 1:no row
ANS 2:All row (because of 1=1 is always true for all rows)

Is This Answer Correct ?

1 Yes

2 No

what is the out put of below queries? a. select * from Emp where null = null; b. select * ..

Answer / rohit

in first case it would response and it will show error and
in second case it will show object belonging to first row
and column

Is This Answer Correct ?

4 Yes

29 No

Post New Answer

More SQL Server Interview Questions

What is instead of trigger sql server?

0 Answers

Diffrence between DTS vs SSIS

2 Answers IBM, Infosys,

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers

What is SQL Profiler and the use of it?

2 Answers 247Customer,

Define indexes?

0 Answers

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers TCS,

How to find index size for each index on table?

0 Answers

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers RND Soft, Wipro,

Why main is user defined function?

0 Answers

What are database states in ms sql server?

0 Answers

For more SQL Server Interview Questions Click Here