What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 45299 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / krishna sandeep
Of course, both the Queries will get you the same data but,
When compared to the first case processing time will be
slightly reduced in the second case.
Bytes sent from client and Bytes received from server will
be more in the first case.
and one more thing is better not using "select * from ..."
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What do you understand by triggers and mention the different types of it?
What is cached report?
What are logical database components? : SQL Server Architecture
Explain foreign key in sql server?
Give an example of why you would want to denormalize a database
What are the types of joins in sql?
Define inner join? Explain with an example?
What is the usage of the sign function?
Can sql servers link to other servers?
What are different backups available in sql server?
write an SQL query to list the employees who joined in the month of January?
What programming language would you use to create embedded functions in ssrs?
How to select all columns of all rows from a table with a select statement in ms sql server?
Is it safe to delete log files?
