Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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 / abinash

Answers were Sorted based on User's Feedback



What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELE..

Answer / 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

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELE..

Answer / vandana chand

where allows only single value in where Clause.
where as IN operator allwos multiple values in Where clause.

Is This Answer Correct ?    0 Yes 0 No

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELE..

Answer / vandana chand

where allows only single value in where Clause.
where as IN operator allwos multiple values in Where clause.

Is This Answer Correct ?    0 Yes 0 No

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELE..

Answer / ved

EMPID=123 will show only one row....if you want to see multiple row then use EMPID IN (1,2,3)


Pratically Done.

Is This Answer Correct ?    3 Yes 5 No

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELE..

Answer / saiteja

there is no difference among them.

Is This Answer Correct ?    2 Yes 8 No

Post New Answer

More SQL Server Interview Questions

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

what is a schema in sql server 2005? : Sql server database administration

0 Answers  

What are types of scd? : sql server analysis services, ssas

0 Answers  

Psudo colums

1 Answers   HP,

Are connections to sql server encrypted?

0 Answers  

What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers  

optimization techinques

0 Answers   Wipro,

Explain the use of containers in ssis?

0 Answers  

What is difference between temp table and cte?

0 Answers  

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

What is mean by dml?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories