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 main purpose of having conversation group?

847


How to get all stored procedures in sql server?

937


What are the different types of backups that exist?

1109


Please illustrate physical database architecture? : SQL Server Architecture

937


How many triggers are possible per table?

1038


How to display a past time in days, hours and minutes?

964


How ssrs maintain security?

1016


Does partitioning help performance?

888


What is query optimizer in sql server?

957


How to download and install the scaled-down database adventureworkslt?

952


Explain the use of containers in ssis and also their types?

909


How many null values we can have in a unique key field in sql server?

903


how can a database be repaired? : Sql server administration

922


What is order of B+tree?

1061


What are the differences between stored procedure and view in sql server?

1159