here...retrieve all column and records of employee. and there is condition

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

Question Posted / amit kumar

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

Please Help Members By Posting Answers For Below Questions

How to execute the cursor queries with "open" statements?

1093

How to delete a login name in ms sql server?

1001

What is enhanced database mirroring in sql server 2008?

912

How can you hide the sql server instances?

970

What are the steps you will take to improve the performance of a poor performing query?

924

explain declarative management framework (dmf) in sql server 2008?

948

Where is trigger in sql server?

984

What is the difference between indexing and hashing?

1072

What is the difference between sdf and mdf?

1228

what are different types of raid configurations? : Sql server database administration

993

What is a collation?

1032

What is “asynchronous” communication in sql server service broker?

958

How do I create an extended event in sql server?

900

What are the general features of sql server management studio? : sql server management studio

1013

what is a correlated sub-query? : Sql server database administration

892