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...

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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I view a trc file?

994


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1062


How to trouble shoot if unable to connect SQL Server

2042


Define primary key?

1205


How to change the password of a login name in ms sql server?

1072


what is a transaction? : Sql server database administration

1059


What do you mean by 'normalization'?

1130


What is sql server profiler?

1064


Explain the use of containers in ssis?

1023


What is use of except clause? How it differs from not in clause?

1068


What do you mean by data integrity?

1136


Explain various On-Delete options in a DB table. Which is the default option?

1541


What is join query?

945


How to connect php with different port numbers?

1157


What are the types of database recovery models?

1201