what is the output for this query
select * from employee where 1=1;
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Why are you getting errors when creating a new odbc dsn?
What is outer join in sql server joins?
What are indexers?
How do I view a procedure in sql server?
What are the different types of joins and what does each do?
How many types of attribute relationships are there? : sql server analysis services, ssas
How to truncate a table first before running a package?
Explain what is lock escalation?
Determine when to use stored procedure to complete sql server tasks?
What is ems sql management studio? : sql server management studio
What are the recovery models in sql server 2000?
What is normalization of database? What are its benefits?