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 are the extra roles available in msdb? : sql server security

1075

How to loop through the result set with @@fetch_status?

1248

What is a field in a table?

979

What is temporal data type?

868

What are the disadvantages of indexes?

994

How to encrypt Strored Procedure in SQL SERVER?

1096

What is rolap and its advantage? : sql server analysis services, ssas

1218

What are the advantages of passing name-value pairs as parameters?

1101

Explain the third normal form(3nf)?

891

What are the various editions of sql server 2017 that are available in the market?

842

What are types of scd? : sql server analysis services, ssas

971

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

992

What is the data type of time?

908

What do you understand by replication in sql server? Mention the different types of replication in sql server.

892

How can you hide the sql server instances?

971