in first query 1=1 always true,then it retrives all columns in a table.

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

Question Posted / g.nageswara rao

Answer Posted / g.nageswara rao

in first query 1=1 always true,then it retrives all columns
in a table.
so,there is no difference in between these two

Is This Answer Correct ?

39 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is Sqlpaging in SqlServer 2005 ?

662

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

539

What do you mean by sql server agent?

544

What is #table in sql server?

537

How to create an index on an existing table in ms sql server?

497

What is function of master database?

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

513

How can we solve concurrency problems?

570

What are the purposes of floor and sign functions?

542

What is change tracking in sql server?

547

What are the commands used in DCL?

560

What is exporting utility?

544

What is in place upgrade in sql server?

524

What is the purpose of optimization?

544

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

460