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 |
explain different levels of normalization? : Sql server database administration
How can we determine what objects a user-defined function depends upon?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
How are the unique and primary key constraints different?
How do I start sql server 2016?
Define full outer join?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
How self join is different from outer join?
wat is tuff file in log shipping, wt is d use of tht file?
What is the significance of null value and why should we avoid permitting null values?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is sql server database?