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 |
IN Vs OR operator which is best to use sql server.
What are indexes? When do you need to create Indexes?
4 Answers CarrizalSoft Technologies, HP,
please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
What does normalization do to data?
What is the difference between HAVING clause and the WHERE clause?
How many databases Microsoft SQL server provides?
What are sub-queries? Give example? In which case sub-queries are not feasible?
Write the SQL query to drop, truncate and delete table.
0 Answers HPCL, Hughes Systique Corporation, Ittiam Systems,
Do you think BCNF is better than 2NF & 3NF? Why?
How to loop through the result set with @@fetch_status?
syntex of insert
What can be used instead of trigger?