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

How to create median function?

156

Explain what is “asynchronous” communication in sql server service broker?

878

What is ms sql server reporting services?

1000

What specific conditions database should meet, before you can bulk copy data into it using bcp?

948

How can you tell if a database object is invalid?

1028

How to create a Master database in SQL server ?

1033

What are extended events in sql server?

911

How do you manipulate data?

858

When should you use an instead of trigger?

922

Which are the important points to note when multilanguage data is stored in a table?

930

What is it’s similarity with sql server?

160

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

941

What are the different authentication modes in sql server? How can it be changed?

1036

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

1004

How data can be copied from one table to another table?

909