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
- 20864 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / g.m. ershad
1)select * from test2 where id=44
Output -
ID NAME
44 Ershad
2) sELECT * FROM test2 WHERE ID IN (44)
Output -
ID NAME
44 Ershad
both will return same output
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
How to insert multiple rows with one insert statement in ms sql server?
What are the elements of dbms?
How to get the definition of a stored procedure back?
How can you insert null values in a column while inserting the data?
Explain multiserver query
How to count groups returned with the group by clause in ms sql server?
Working with TLogs
How to remove duplicate rows from table?
Do you know what are the steps to process a single select statement?
Do you know the cursor optimization tips?
if no size is defined while creating the database, what size will the database have? : Sql server administration
How many non clustered indexes there can be on table ?
What do you mean by table and field in sql?
What is the difference between push and pull subscription? : sql server replication
What are constraints?
