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
What is the main purpose of having conversation group?
How to get all stored procedures in sql server?
What are the different types of backups that exist?
Please illustrate physical database architecture? : SQL Server Architecture
How many triggers are possible per table?
How to display a past time in days, hours and minutes?
How ssrs maintain security?
Does partitioning help performance?
What is query optimizer in sql server?
How to download and install the scaled-down database adventureworkslt?
Explain the use of containers in ssis and also their types?
How many null values we can have in a unique key field in sql server?
how can a database be repaired? : Sql server administration
What is order of B+tree?
What are the differences between stored procedure and view in sql server?