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

What is after dml trigger?

989

how many no of arguments can be passed in procedures and functions

5526

What is the new security features added in sql server 2016? : sql server security

1087

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

978

What is format parameter in ssrs?

144

What is a benefit of using an after insert trigger over using a before insert trigger?

966

what is unique and xaml nonclustered index

1027

What happens when unicode strings concatenate with non-unicode strings?

1061

Why do we need different type of parameter?

1036

what is a join and explain different types of joins? : Sql server database administration

939

What is function of CUBE ?

1012

How to create a large table with random data for index testing in ms sql server?

1010

What is trace flag in sql server?

1004

How to change the password of a login name in ms sql server?

998

Are semicolons required at the end of sql statements in sql server 2005?

964