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


Please Help Members By Posting Answers For Below Questions

What the different components of Replication and what is their use?

832


What are the different types of stored procedures?

872


How to execute a sql statement using odbc_exec()?

814


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

797


Are semicolons required at the end of sql statements in sql server 2005?

794


How to return the top 5 rows from a select query in ms sql server?

845


What is the use of commit?

799


How to provide default values to stored procedure parameters?

817


What is the difference function and stored procedure?

777


How to define output parameters in stored procedures?

775


How to drop an existing table?

788


Write an SQL query to obtain the 2nd highest salary.

866


How to rebuild master databse?

878


Explain transaction server implicit?

754


What is a matrix in ssrs?

127