What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
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 |
Post New Answer View All Answers
What the different components of Replication and what is their use?
What are the different types of stored procedures?
How to execute a sql statement using odbc_exec()?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Are semicolons required at the end of sql statements in sql server 2005?
How to return the top 5 rows from a select query in ms sql server?
What is the use of commit?
How to provide default values to stored procedure parameters?
What is the difference function and stored procedure?
How to define output parameters in stored procedures?
How to drop an existing table?
Write an SQL query to obtain the 2nd highest salary.
How to rebuild master databse?
Explain transaction server implicit?
What is a matrix in ssrs?