Here both is same but some situvations we want extact value of one are mor

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?

Question Posted / guest

15 Answers
21887 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

Please Help Members By Posting Answers For Below Questions

what is package and it uses and how can u call a package

2067

What are views in ms sql server?

1121

What are drilldown reports?

160

What is sql server agent and what are the two modes of authentication in sql server?

1112

What are the different types of locks in the database?

975

What is the difference between ddl,dml and dcl commands?

1160

How to encrypt data between dialogs?

1169

Explain aggregate functions?

1141

How to set database to be read_only in ms sql server?

1054

What is field in algebra?

1094

What are cursors in ms sql server?

1244

What is hot add cpu in sql server 2008?

986

What are the restraints imposed on the table design by a merge replication?

1094

What are user-defined functions (udfs) in sql server?

1051

What are the types of database recovery models?

1190