No Diffrence at all

What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table

Question Posted / rajiv rohilla

Answer Posted / rajiv rohilla

No Diffrence at all

Is This Answer Correct ?

57 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What happens if you add a new index to large table?

942

Mention the differences between local and global temporary tables.

1043

How to return the second 5 rows in ms sql server?

1059

Can sql server be linked with other servers like oracle?

966

How to backup SQL Server Reporting Services ?

149

What is Lock table in SQL?

1473

What is the boxing and unboxing concept in .net?

919

How many levels of sp nesting are possible?

1028

What the difference between UNION and UNIONALL?

1040

How to run sql server 2005 books online on your local system?

961

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1017

Do you know the cursor types?

1156

What is a trace frag? Where do we use it?

1100

How to retrieve field values using mssql_result()?

1316

What is table-valued sub query?

970