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

Define clusters?

999

How many types of objects are there?

937

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

954

Does the unique constraint create an index?

991

Explain a differential backup?

949

Difference between report and query parameter.

1026

What is pessimistic concurrency?

924

Can you explain various data region available in ssrs with their use?

918

What are window functions in sql server?

940

Can you index views?

853

What is the server name in sql server?

959

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

940

Determine how to use the inserted and deleted pseudo tables?

930

What is temporal data type?

875

Explain magic tables in sql server?

985