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

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

Question Posted / mohanakrishna

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

Please Help Members By Posting Answers For Below Questions

Do comments need to go in a special place in sql server 2005?

853

What are the essential components of sql server service broker?

1016

What is a document index?

1022

How to enter binary string literals in ms sql server?

1152

What are the indexes in sql server?

1107

Can a table have 2 foreign keys?

903

What are a scheduled jobs or what is a scheduled tasks?

899

Mention what are the core components of ssrs?

323

Explain in brief about Microsoft SQL server?

1088

Explain error and transaction handling in sql server?

1007

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1182

How to get the definition of a stored procedure back?

976

What are different types of raid configurations? : SQL Server Architecture

1069

How to update multiple rows with one update statement in ms sql server?

1202

Is it important for a database administrator to understand the operating system and file access?

978