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 / hitesh taneja
When we use 1=1 or any condition which is always going to
true, it will take extra bit of time bcoz it is a condion so
althouth the output of the query will be the same the
performance time will be bit higher with condition.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vidit
The results of both queries will be same
but 2nd will fast then 1st
vidit Tyagi
Meerut
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / niranjan prasad
There is no defference in result. It shows same result-set
by using both the command.This question put you to misguide
only.
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / chinnu
Hi SQL gurus,
i am working for an MNC...
My team is having a problem in sql server. when user slects
date prompts from jan 1st to april 30, it should display
all months data like :
jan aa
feb bb
mar cc
but when it comes to april its taking data like :
jan aa
feb bb
mar cc
apr dd...and so on
means its taking data again from jan to april which we dont
want. we want the data only april month as we are getting
jan, feb and mar...
can any one write the code to relsove the issue please
would be greatful if you can send to shiva_sans@yahoo.co.in
and also please send your email also ...so that we will be
in touch for any kind of queries ...
Thanks a lot in Advance !!!
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rohit nanda
NO DIFFERENCE IN BOTH THE EQUATION...BCOZ THEY GIVE THE SAME
OUTPUT....
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kohulavani.g
First query,in table where 1=1 condition is satisfied that
row or column is displayed
But in second query,the whole table is displayed
Is This Answer Correct ? | 18 Yes | 44 No |
Answer / kranthi kiran
I am learning SQL Basics..So If my Answer is wrong Plz do
reply to tht,
In the First Query Where 1=1 implies Show all where The
first coloum element is equal to 1
and second query show all from table
Is This Answer Correct ? | 4 Yes | 40 No |
Define Foreign Key?
3 Answers ADP, College School Exams Tests,
Explain insert into select statement?
What is meant by datasource?
Differentiate between truncate vs delete in mssql?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h
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 are mdf,ndf,ldf files and how to see the data in those files?
What are “lost updates”?
What are the basic functions for master, msdb, model, tempdb databases?
Describe about first three Normal forms.
What is logshipping and its purpose?
How can we use ConnectorJ JDBC Driver with MS SQL?