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
- 21454 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / guest
Here both is same but some situvations we want extact value
of one are more values then use in oprate
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain query editor regions
What is the full form of ddl?
why would you use sql agent? : Sql server database administration
Explain differences between web edition and business edition?
Why use “nolock” in sql server?
What are the filtered indexes?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is the default Port No on which SQL Server listens?
What is it unwise to create wide clustered index keys?
What is a dbms wizard?
Can two tables share a primary key?
What is difference between index seek vs. Index scan?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Why it is recommended to avoid referencing a floating point column in the where clause?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
