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

No Diffrence at all

Both the Queries will return the same ouput.
That means it will return all the rows that are available 
in the table.

in first query 1=1 always true,then it retrives all columns 
in a table.
so,there is no difference in between these two

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

There is No Difference between these two

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.

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.

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 ..."

Both are same .
They r showing all results.

The first query satisfies the condition true condition.

both are similar but not same. performance based querys ...

No difference

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.

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 !!!

The results of both queries will be same
but 2nd will fast then 1st

vidit Tyagi
Meerut