Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

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 a rollup clause?

0 Answers  

Why is DML provided?

1 Answers   Ernst Young, Thomson Reuters,

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

What are the different types of backups that exist?

0 Answers   ADITI,

How do I setup a sql server database?

0 Answers  

List some advantages and disadvantages of stored procedure?

0 Answers  

What does asynchronous call backs means?

0 Answers   Alcatel-Lucent,

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

Can we install sql server 2016 on windows 7?

0 Answers  

Can we use pragma autonomous_transaction in trigger?

0 Answers  

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

0 Answers  

What do you need to connect php to sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories