What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answers were Sorted based on User's Feedback
Answer / 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 |
in first query 1=1 always true,then it retrives all columns
in a table.
so,there is no difference in between these two
Is This Answer Correct ? | 39 Yes | 3 No |
Both are returns the SAME results.
I dont know the meaning of the
SELECT * FROM Table_Name WHERE 1=1
SELECT * FROM Table_Name WHERE 2=2
SELECT * FROM Table_Name WHERE 5=5
SELECT * FROM Table_Name WHERE 100=100
.
.
.
etc..,
It accepts the where both are equal.
If you give like
SELECT * FROM Table_Name WHERE 100=1001
It is not accept.
Is This Answer Correct ? | 34 Yes | 1 No |
Answer / 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 |
Answer / 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 |
Answer / akbar ali
The first query satisfies the condition true condition.
both are similar but not same. performance based querys ...
Is This Answer Correct ? | 8 Yes | 1 No |
What is the function of sql server agent windows service?
How you trouble shoot when any job fails
How to set database to be read_only in ms sql server?
How to convert numeric values to integers in ms sql server?
Which index created when Create Index on table(col), Why
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
How do I open a .db file?
What is postgresql server?
What are the new scripting capabilities of ssms? : sql server management studio
What is clustered vs nonclustered index?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What are different types of database indexes?