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
- 19386 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
Please explain go command in sql server?
Explain the dirty pages?
How do I manually uninstall an instance of sql server 2016?
What is the difference between nvl and nvl2?
What is the sql case statement used for?
Why do you need a sql server?
How can sql server instances be hidden?
What does it mean to manipulate data?
What is indexed view?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Explain primary key?
What is wide table?
What is the server name for sql management studio?
What is the command dbcc checkdb used for?
Does the order of columns in update statements matter?
