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
- 14288 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
What are types of subqueries?
How to define output parameters in stored procedures?
How to create a testing table with test data in ms sql server?
How many types of subqueries are there in sql server?
New concepts of sql server 2005 use in your project.
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Find nth lowest salary or get nth lowest salary?
Explain tables in SQL Azure?
Explain the advantages of merge replication?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is a field in a table?
Do you know what is normalization of database? What are its benefits?
How important do you consider cursors or while loops for a transactional database?
Explain sql delete command?
What is the difference between getdate and sysdatetime?
