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 the xml datatype?

989

Difference between Inner vs outer joins?

894

what is the difference between count(*) and count(1) ?

1026

Who developed sql server?

875

Can a database be shrunk with users active?

1063

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

304

What is the difference between ddl and dml?

1002

What do you understand by mirroring?

951

Why use view instead of a table?

879

When I run the sql server 2000 setup, it just hangs. What do I do?

1016

Explain the concept of recursive stored procedure.

879

How to list all dsn entries on your local machine using odbc_data_source()?

978

What language is sql server written in?

985

Why we should not use triggers?

919

Explain primary key in sql server?

970