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

how to control the amount of free space in your index pages? : Sql server database administration

994

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

996

What is triggers and stored procedures?

902

What is the most common trace flags used with sql server?

982

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

858

What are click through reports?

140

What are different type of Collation Sensitivity?

953

What are temporal tables in sql server 2016?

844

Write a SQL queries on Self Join and Inner Join.

994

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1072

How to drop existing views from a database in ms sql server?

1051

What is enhanced database mirroring in sql server 2008?

921

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

949

How can you tell if a database object is invalid?

1028

What is scan table/view and seek table/view when its occurs? : sql server database administration

996