Both the Queries will return the same ouput. That means it will return all

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

Question Posted / malathi

Answer Posted / malathi

Both the Queries will return the same ouput.
That means it will return all the rows that are available
in the table.

Is This Answer Correct ?

45 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1099

What is user-defined function?

1034

Why truncate is ddl?

1133

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1003

What is field with example?

976

In which files does sql server actually store data?

953

Why I am getting this error when renaming a database in ms sql server?

1106

How to create dbo table in sql server?

1004

What is the use of builtinadministrators group in sql server? : sql server security

1106

How will you add a dimension to cube? : sql server analysis services, ssas

1136

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

1050

Can you please differentiate between a primary key and a unique key?

1048

How to enter comments in transact-sql statements?

987

What is relationship? What number of sorts of relationship are there?

1223

What is the data tier application?

169