what is the output for this query
select * from employee where 1=1;
- 4 Answers
- 13179 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
Explain what is use of dbcc commands?
What the different types of Replication and why are they used?
What is log ldf?
What is Federation Root Database?
Explain the flow of creating a cube? : sql server analysis services, ssas
How to connect ms access to sql servers through odbc?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What are user-defined functions (udfs) in sql server?
Describe in brief authentication modes in sql server.
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is difference between global temporary tables and local temporary tables?
What is the use of nvl work?
How do you create a clustered index?
Explain contrast amongst grouped and non-bunched records?
Explain what is raid and what are different types of raid levels?
