NO DIFFERENCE IN BOTH THE EQUATION...BCOZ THEY GIVE THE SAME OUTPUT....

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

Question Posted / rohit nanda

Answer Posted / rohit nanda

NO DIFFERENCE IN BOTH THE EQUATION...BCOZ THEY GIVE THE SAME
OUTPUT....

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain stored procedure?

1053

How do database indexes work?

1009

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1086

How do you clear a log file?

1047

Explain about merge replications?

1021

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

958

What is instead of trigger sql server?

1000

Tell me what is the significance of null value and why should we avoid permitting null values?

984

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1024

What is precedence constraint?

983

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1061

What is postgresql server?

999

What is a unique index?

932

How can sql server instances be hidden? : sql server security

1146

How do use Having,Group by,Group function in SQL?

1741