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 purpose of the master database?
How is table type constraint applied to a table?
What is sharding?
What is data modification?
Which is the main third-party tool used in sql server?
Explain system views?
Is mysql the same as sql server?
Suggest a method of joining two tables.
What is the difference between char, varchar and nvarchar?
What is federation member?
Can we use where and having clause together?
What does normalization do to data?
List out different types of normalizations in sql server and explain each of them?
When do you think a developer should use sql server-based cursors?
Please explain go command in sql server?