The first query satisfies the condition true condition. both are similar

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

Question Posted / akbar ali

Answer Posted / akbar ali

The first query satisfies the condition true condition.

both are similar but not same. performance based querys ...

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is difference between views and tables?

1011

What are different types of replication in sql server?

1087

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1147

What is tempdb in sql server?

976

Why we use trigger in sql server with example?

961

What is “asynchronous” communication in sql server service broker?

1034

What are the advantages of using a stored procedure?

1008

What is the default sql server instance name?

1036

what are defaults? : Sql server database administration

1093

What are the advantages of mirroring?

995

How many ways to create table-valued functions?

987

What are different types of statement?

1018

What is difference between Datepart() and Datename() in SqlServer?

1206

What is normalization of database?

1105

Explain the concept of view and Types of views in SQL server?

993