What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 45395 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / malathi
Both the Queries will return the same ouput.
That means it will return all the rows that are available
in the table.
| Is This Answer Correct ? | 45 Yes | 3 No |
Post New Answer View All Answers
What are the steps to process a single select statement?
Explain about protocol layer present in SQL server?
What is merge statement?
What is named query? : sql server analysis services, ssas
What is difference between aggregate and analytic function?
What is for xml in sql server?
How can I know what locks are running on which resource?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What is the command to change the recovery model?
What are the types of indexes?
How to drop existing indexes in ms sql server?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is the default value of an integer data type in sql server 2005?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Do you know what is similarity and difference between truncate and delete in sql?
