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

Question Posted / om namo bhagavathe vasudevaya

Answers were Sorted based on User's Feedback



what is the output for this query select * from employee where 1=1;..

Answer / 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

what is the output for this query select * from employee where 1=1;..

Answer / 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

what is the output for this query select * from employee where 1=1;..

Answer / mohanakrishna

The querry display the total table information present in
the database.

EID ENAME MID
101 rama null
102 sita 101
103 siva 101
104 ganesh 103

Is This Answer Correct ?    5 Yes 1 No

what is the output for this query select * from employee where 1=1;..

Answer / guest

Retriving all employee table records

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What is nolock?

0 Answers  

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

What is SQL server agent?

2 Answers   HCL, SAP Labs,

What is the default schema of your login session in ms sql server?

0 Answers  

What is the difference between mysql and sql server?

0 Answers  

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

How to bind a view to the schema of the underlying tables?

0 Answers  

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

Name three of the features managed by the surface area configuration tool? : sql server security

0 Answers  

How to change a login name in ms sql server?

0 Answers  

In what three ways is the return statement used in a stored procedure?

0 Answers  

what is the difference between group and having give an example with query and sample output

7 Answers  

For more SQL Server Interview Questions Click Here
Categories