Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 49774 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 is the exact numeric data type in sql?
How can we delete Duplicate row in table?
How will you add a dimension to cube? : sql server analysis services, ssas
Can we add a cpu to sql server?
What the difference between UNION and UNIONALL?
What are the differences between DDL, DML and DCL in SQL?
What is sql sandbox in sql server?
How to encrypt data between dialogs?
What does the on delete cascade option do?
What is co-related sub query?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
how many type of indexing in database?
What is sql profiler. What are the default templates with it? : sql server database administration
In how many ways you can invoke ssrs reports?
How connect excel to sql server?
