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

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

935

What is attribute hierarchy? : sql server analysis services, ssas

1024

can we have a nested transaction? : Sql server database administration

1103

What is SQL Azure?

107

What do you mean by authentication modes in sql server?

1087

How do you use a subquery to find records that exist in one table and do not exist in another?

1051

What is reportserver and reportservertempdb ?

152

Which are the important points to note when multilanguage data is stored in a table?

1000

What is the significance of master, tempdb and model databases?

1080

What is the difference between row_number and dense_rank?

881

explain different types of joins? : Sql server database administration

988

What is report snapshot in ssrs?

270

Explain about integration services of Microsoft SQL server?

1038

How do I open a .db file?

1042

How to insert data into an existing table?

980