in first query 1=1 always true,then it retrives all columns in a table.

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

Question Posted / g.nageswara rao

Answer Posted / g.nageswara rao

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

Is This Answer Correct ?

39 Yes

3 No

Please Help Members By Posting Answers For Below Questions

You want to implement the many-to-many relationship while designing tables. How would you do it?

965

Why do we use non clustered index?

1024

what is the difference between Tabular and Matrix report?

164

How to drop an existing table?

970

What are dml triggers and types of dml triggers?

937

List out the differences between the clustered index and non-clustered index in sql server?

953

If we delete pack Spec what will be the status of pack Body ?

1447

How can I check if a view exists in a sql server database?

990

What is openxml in sql server?

1126

Explain how would you store your query in an SSRS report or a Database server?

116

Explain log shipping and mention its advantages.

998

how you can deploy an ssrs report?

174

How to create user defined functions with parameters?

1179

Explain active/passive and active/active cluster configurations?

1027

Give me a SQL Query to find out the second largest company?

1129