There is no defference in result. It shows same result-set by using both

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

Question Posted / niranjan prasad

Answer Posted / niranjan prasad

There is no defference in result. It shows same result-set
by using both the command.This question put you to misguide
only.

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is intellisense?

1044

What are the recovery models for a database?

1100

Name three of the features managed by the surface area configuration tool? : sql server security

986

Explain relational data?

912

What do you mean by data manipulation language?

1008

how to create “alternate row colour”?

146

What is sql stored procedure?

1083

List out a number of the wants to setup a SQL Server failover cluster?

1062

What is the difference between system objects and user objects?

1157

What is log ldf?

975

What are the benefits and tasks of object explorer? : sql server management studio

1175

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2477

Mention a few common trace flags used with sql server?

925

what are constraints? : Sql server database administration

1051

What is subreport?

141