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

Explain in brief about Microsoft SQL server?

1170

Explain about Normalization?

1121

We need to perform what steps in the following order to work with a cursor?

1273

What is a domain constraint give an example?

1108

Explain database normalization?

1266

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1107

Explain the third normal form(3nf)?

982

Explain timestamp datatype?

1017

What is difference statement and preparedstatement?

1031

What is implicit cursors?

1129

What is meant by dirty read?

1039

Explain how many types of relationship?

1083

What do you understand by a view? What does the with check option clause for a view do?

1054

What is a hint?

1056

What are the differences between lost updates and uncommitted dependencies?

1138