Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output for this query
select * from employee where 1=1;
- 4 Answers
- 14470 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many databases instances are there in sql server 2000?
System variable and temporary variables
If user is owning any SQL Objects, can we drop that user
What are the advantages of paper records?
Why truncate is ddl command?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is difference between foreign key and unique key?
what is the information that can be stored inside a bit column? : Sql server database administration
Explain triggers in sql?
Explain filtered indexes?
Explain the working of sql privileges?
How to stop log file growing too big?
How do I connect to sql server database?
What is a collation?
What is difference between aggregate and analytic function?
