Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between WHERE AND IN?
OR
1. SELECT * FROM EMPLOYEE WHERE EMPID=123
2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123)
WHAT IS THE DIFFERENCE?
- 15 Answers
- 21094 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / saiteja
there is no difference among them.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
Explain where clause?
How can you control the amount of free space in your index pages?
What is a partitioned view?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Explain features and concepts of analysis services?
What are the difference between clustered and a non-clustered index?
What is a Join and explain its types?
Can we use where and having clause together?
What are the benefits and tasks of object explorer? : sql server management studio
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Define Business Edition in SQL Azure?
Define a cross join?
What is row_number () and partition by in sql server?
Explain having clause?
