First query,in table where 1=1 condition is satisfied that row or column

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

Question Posted / kohulavani.g

Answer Posted / kohulavani.g

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

Is This Answer Correct ?

18 Yes

44 No

Please Help Members By Posting Answers For Below Questions

What happens if null values are involved in datetime operations?

1021

Why transaction is important?

1021

Can two tables share a primary key?

1079

Can you explain what is sql server english query?

1054

Can you edit the .rdl code associated with a linked report?

168

How to insert and update data into a table with "insert" and "update" statements?

1042

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1125

Explain collation?

1100

How to use subqueries with the exists operators in ms sql server?

1178

what is the information that can be stored inside a bit column? : Sql server database administration

1010

Mention the different types of triggers?

1202

What is application role in sql server database security? : sql server security

1119

Explain differences between web edition and business edition?

119

Explain powershell included in sql server 2008?

1114

What is the default port for SQL Server over a firewall?

1143