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

How do you delete duplicate records in sql server?

1125

Can we take the full database backup in log shipping?

993

what is checksum in sql server.........???

1744

How to use the inserted and deleted pseudo tables?

1001

Explain about local stored procedure?

1027

Do you know sql server 2008 introduces automatic auditing?

1047

How do I port a number to sql server?

1090

What is sql server transaction log file?

1103

Explain the difference between control flow and data flow?

1054

What are the fixed server level roles? : sql server security

1214

How to generate create function script on an existing function?

1173

do views contain data ?

1018

Explain about SQLOS?

1054

How to stop log file growing too big?

1059

What is the sql case statement used for?

1129