No Diffrence at all

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

Question Posted / rajiv rohilla

Answer Posted / rajiv rohilla

No Diffrence at all

Is This Answer Correct ?

57 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Write a program to fetch first 10 records from a file?

1009

What part does database design plays a role in performance of an sql server-based application?

980

Why do we partition data?

1028

Can you please differentiate between a primary key and a unique key?

1008

How to get a list of columns using the "sys.columns" view in ms sql server?

954

How to encrypt data between dialogs?

1107

How to create an index on a view?

1068

What is the purpose of the model database?

1015

Which are new data types introduced in sql server 2008?

1049

How to delete exactly duplicate records from a table?

1063

What are types of subqueries?

1063

What is the difference between a stored procedure and a user defined function?

1020

Why we need sql server?

960

What is factless fact table? : sql server analysis services, ssas

1027

How to generate random numbers with the rand() function in ms sql server?

1150