NO DIFFERENCE IN BOTH THE EQUATION...BCOZ THEY GIVE THE SAME OUTPUT....

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

Question Posted / rohit nanda

Answer Posted / rohit nanda

NO DIFFERENCE IN BOTH THE EQUATION...BCOZ THEY GIVE THE SAME
OUTPUT....

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to grant a permission in ms sql server using "grant execute" statements?

1053

what does the automatic recovery do? : Sql server administration

981

What happens if ntwdblib.dll is missing on your machine?

1119

What is sub-query in sql server?

1169

What is bcp? When does it used?

950

What is sparse columns of sql server 2008?

1010

Explain what is dbcc?

983

What are the differences between sql server and mysql.

1052

What happens if date-only values are provided as date and time literals?

991

When multiple after triggers are attached to sql table, how to control the order of execution?

1006

Do you know what guidelines should be followed to help minimize deadlocks?

936

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

904

Explain index in sql server?

973

What is the default value of an integer data type in sql server 2005?

923

How can you list all the table constraints in a database?

897