There is No Difference between these two

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

Question Posted / vijay

Answer Posted / vijay

Is This Answer Correct ?

35 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is a non-clustered index?

998

How to delete duplicate records based on single column from a table?

1050

How do you improve the performance of a SQL Azure Database?

137

What is the difference between a stored procedure and a user defined function?

1020

what is an index? : Sql server database administration

982

What factors you will consider calculating the storage requirement for that view?

949

What is tcl in sql server?

1123

How would we use distinct statement? What is its use?

1072

Explain what is dbcc?

1010

Do you know what are the properties of the relational tables?

1031

Can sql server 2016 run on windows 7?

916

Which database stores information about replication?

1068

Can we perform backup restore operation on tempdb? : sql server database administration

998

Explain powershell included in sql server 2008?

1055

What is a subquery in a select query statement in ms sql server?

1131