Both are same . They r showing all results.

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

Question Posted / hasan

Answer Posted / hasan

Both are same .
They r showing all results.

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is implicit mode in sql server?

1043

How to delete duplicate records based on single column from a table?

1008

What is the difference between dropping a database and taking a database offline?

1131

What is a scheduled job or what is a scheduled task?

920

How can I add Reporting Services reports to my application?

129

Explain Capacity planning to create a database? and how to monitor it?

4158

What are the differences between having and where clause.

938

What is trigger explain with program?

946

what is a live lock? : Sql server database administration

912

What authentication modes does sql server support?

1040

What are pessimistic lock and optimistic lock?

1013

Mention a few common trace flags used with sql server?

902

What is updatable resultset?

953

what are candidate key, alternate key and composite key? : Sql server database administration

869

Explain what are the basic functions for master, msdb, model, tempdb databases?

929