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

Answers were Sorted based on User's Feedback



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

Answer / soorai ganesh

This Query will return all records from employee table.

Infact insteadof this query u can use " select * from employee ".Because the condition 1=1 is always true.It never become as false.

Both of the Queries are same..........

Is This Answer Correct ?    20 Yes 0 No

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

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

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

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

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

Answer / guest

Retriving all employee table records

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More SQL Server Interview Questions

Why are you getting errors when creating a new odbc dsn?

0 Answers  


What is outer join in sql server joins?

0 Answers  


What are indexers?

0 Answers  


How do I view a procedure in sql server?

0 Answers  


What are the different types of joins and what does each do?

2 Answers  






How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  


How to truncate a table first before running a package?

1 Answers  


Explain what is lock escalation?

0 Answers  


Determine when to use stored procedure to complete sql server tasks?

0 Answers  


What is ems sql management studio? : sql server management studio

0 Answers  


What are the recovery models in sql server 2000?

0 Answers  


What is normalization of database? What are its benefits?

0 Answers  


Categories