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 rename an existing column with sql server management studio?

949

What are the difference between primary key and unique key? : sql server database administration

894

which backup strategy you are following at ur company

2103

What are tables in sql server?

965

What area unit the various kinds of info compression introduced in sql server 2008?

1038

What is unpivot?

971

How to find related tables in sql server?

872

Tell me the difference between clustered and non-clustered index?

885

Explain the benefits of user-defined functions?

989

What is constraints and its types?

878

What is the use of =,==,=== operators?

960

What is openrowset sql server?

1064

Explain what is scheduled job and how to create it?

904

What is the use of floor function in sql server?

1025

Can we write ddl in trigger?

867