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 / amit kumar

here...retrieve all column and records of employee. and
there is condition 1 = 1 is always true if 1 value in any
column.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In which sql server version report builder introduced?

149


Explain sql server authentication modes?

1134


What is in place upgrade in sql server?

1045


you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

948


Can you insert NULL in unique column?

1162


What is the importance of a recovery model?

1049


Explain about service Broker functions?

1032


What are the differences between lost updates and uncommitted dependencies?

1080


How to make a remote connection in a database?

977


How do you use a subquery to find records that exist in one table and do not exist in another?

1050


What is extent? Types of extents?

1195


What are the different types of sub-queries?

1044


What are the different type of replication in sql server?

981


What are the elements of dbms?

967


Tell about MOM Tool(Microsoft Operator Manager)?

1914