The results of both queries will be same but 2nd will fast then 1st vid

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

Question Posted / vidit

Answer Posted / vidit

The results of both queries will be same
but 2nd will fast then 1st

vidit Tyagi
Meerut

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can foreign key be duplicate?

999

What is the purpose of the tempdb database?

958

explain different types of constraints? : Sql server database administration

913

How each E-R model constructs can be mapped to the relational model?

920

What is the usage of sign function?

1038

How to return the top 5 rows from a select query in ms sql server?

1073

How do I delete a sql server database?

984

What is the purpose of the model database?

962

explain extended properties

927

Which are the third-party tools used in sql server and why would you use them?

843

What is a join in sql?

1018

What is similarity and difference between truncate and delete in sql?

1028

Can group by and orderby be used together?

963

What is normalization? Explain different forms of normalization?

1070

How will you make an attribute not process? : sql server analysis services, ssas

1008