What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 45295 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / pavan
hey! I too agree there wont be any difference in result it
displays but the performance will be different. While
executing the first query the where condition to be checked
for each record it displays hence it takes much time to
execute while compared with question no 2 i.e, without
where condition. this is what I believe in.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
How to provide values to stored procedure parameters in ms sql server?
How to create stored procedures with parameters in ms sql server?
What is an indexing technique?
What’s the distinction between dropping a info and taking a info offline?
Tell me about joins in database system and explain each in detail.
How we can compare two database data?
What is the difference between rank and dense_rank?
Scalability, Availability, Integration with internet, etc.)?
What is sql service broker?
what are database files and filegroups? : Sql server database administration
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Please illustrate physical database architecture? : SQL Server Architecture
How to filter records of table in SQL SERVER?
Explain what is public role in sql server?
Does the order of columns in update statements matter?
