Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output for this query
select * from employee where 1=1;
- 4 Answers
- 14309 Views
- I also Faced
- E-Mail Answers
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
How to create a simple user defined function in ms sql server?
What are the restrictions that views have to follow?
what method you can use to reduce the overhead of Reporting Services data sources?
How to create a view using data from another view?
Where do you find the default Index fill factor and how to change it?
between cast and convert which function would you prefer and why?
Please differentiate between a local and a global temporary table?
What are the types of normalization?
Where cross join is used?
Why do we need normalization?
Do you know how to make remote connection in database?
Explain the properties of the relational tables?
How will you optimize a stored procedure optimization?
What is database replication? What are the different types of replication you can set up in sql server?
What is self contained scalar sub query?
