what is the output for this query
select * from employee where 1=1;
Answer Posted / soorai ganesh
This Query will return all records from employee table.
Infact insteadof this query u can use " select * from employee ".Because the condition 1=1 is always true.It never become as false.
Both of the Queries are same..........
Is This Answer Correct ? | 20 Yes | 0 No |
Post New Answer View All Answers
Can group functions be mixed with non-group selection fields in ms sql server?
What is the full form of dql?
Explain what are partitioned views and distributed partitioned views?
What is the purpose of a table?
What is the difference function and stored procedure?
Give main differences between "Truncate" and "Delete".
What is difference between getdate and sysdatetime in sql server 2008?
How to concatenate two character strings together?
Differentiate between sql temp table vs table variable?
Is it safe to delete log files?
How to invoke a trigger on demand?
How can you insert null values in a column while inserting the data?
What is the difference between locking and multi-versioning?
List out the difference between union and union all in sql server?
How to remove duplicate rows from table except one?