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

What are rows and columns?

1019

What number aggregate functions are accessible there in sql?

1073

What is SQL Server?

1213

How do I start sql server 2016?

908

What is indexed view? How to create it?

1009

Is it safe to delete log files?

919

How to optimize stored procedures in sql server?

1185

Explain how to integrate the ssrs reports in application?

1017

What is mean by dml?

1010

what changed between the previous version of sql server and the current version? : Sql server database administration

1008

how you can list all the tables in a database?

1026

What is always encrypted?

995

What are the limitations in ssrs on sql server express edition?

186

What is row-level compre?

1002

How do you set a trace flag in sql server?

1036