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 is de-normalization in sql database administration? Give examples?

984

What are the purposes of floor and sign functions?

978

where can you add custom error messages to sql server? : Sql server administration

1120

What is the new security features added in sql server 2014? : sql server security

1000

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1066

How to Insert multiple rows with a single insert statement?

1056

Explain security with sql azure?

186

What is tablix?

162

What is the difference between Stored Procedures and triggers?

1082

What is the server name in sql server?

1010

What are examples of triggers?

1088

How to count duplicated values in a column in ms sql server?

1095

What happens on checkpoint?

1024

What is difference between count (*) and count column?

904

What is the Main Difference between ACCESS and SQL SERVER?

1136