Both the Queries will return the same ouput. That means it will return all

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

Question Posted / malathi

Answer Posted / malathi

Both the Queries will return the same ouput.
That means it will return all the rows that are available
in the table.

Is This Answer Correct ?

45 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is an entity-relationship diagram (erd)?

813

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

717

Does an index slow down updates on indexed columns?

718

How does using a separate hard drive for several database objects improves performance right away?

699

Explain how to maintain a fill factor in existing indexes?

721

Explain Reporting Life Cycle?

102

What are the underflow and overflow behaviors on float literals?

784

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

1537

What are the new features of sql server 2012 reporting service?

Explain log shipping and mention its advantages.

783

What are entities and relationships?

739

How to use copy and concatenate commands in SQL?

776

What are the Advantages of using CTE in sql server?

766

What is thr feature of change data capture?

674

How to find Duplicate Records In table?

759