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 output for this query
select * from employee where 1=1;

Answer Posted / soorai ganesh

This Query will return all records from employee table.

Infact insteadof this query u can use " select * from employee ".Because the condition 1=1 is always true.It never become as false.

Both of the Queries are same..........

Is This Answer Correct ?    20 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of the master database?

1106


How is table type constraint applied to a table?

967


What is sharding?

116


What is data modification?

945


Which is the main third-party tool used in sql server?

927


Explain system views?

1069


Is mysql the same as sql server?

960


Suggest a method of joining two tables.

1144


What is the difference between char, varchar and nvarchar?

1010


What is federation member?

114


Can we use where and having clause together?

1024


What does normalization do to data?

1046


List out different types of normalizations in sql server and explain each of them?

914


When do you think a developer should use sql server-based cursors?

1023


Please explain go command in sql server?

1029