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 are the aggregate and scalar functions?

1131

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

990

Explain transaction server implicit?

1028

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

1037

How do you troubleshoot errors in a SQL Server Agent Job?

1104

What is 2nf in normalization?

1055

What will happen if a column containing char type data is changed to the nchar data type?

1151

What are orphan records?

986

How many databases can we create in a single server?

209

How to write a query with an inner join in ms sql server?

1094

Explain Normalization and DE normalization

1160

What are ddl (data definition language) statements for tables in ms sql server?

1150

What will be query used to get the list of triggers in a database?

1053

What are the different types of stored procedures?

1155

What is the process of normalization?

1180