In the WHERE clause what is BETWEEN and IN?

bluesky · #1 (**permalink**) 07-25-2007, 05:41 AM

priyan · #2 (**permalink**) 07-25-2007, 07:27 AM

Hi,

We can use BETWEEN .. AND condition where we dont know the actual search values, so we can
use range of values that satisfies the condition.

fox example, if want to fetch the employee details who earn more than 10000 and not more than
20000, in this situation we can deploy BETWEEN.. AND condition.

Quote:

Here we have the table 'emp'-

SELECT * FROM emp;
---------------------------------------
emp_id emp_name emp_sal
---------------------------------------
1 John 15000
2 Smith 1500
3 Mike 10000
4 rAj 1500
---------------------------------------

SELECT * FROM emp WHERE emp_sal BETWEEN 10000 AND 20000;
---------------------------------------
emp_id emp_name emp_sal
---------------------------------------
1 John 15000
3 Mike 10000
---------------------------------------

Whereas in IN() condition we must know the search key values, here we are not using range
values but the actual search values with comma seperator.

Look at the below given query, this will return the employees who earn 1500 and 10000 salary.

Quote:

SELECT * FROM emp WHERE emp_sal IN(1500,10000);

Quote:

------------------------------------
emp_id emp_name emp_sal
------------------------------------
2 Smith 1500
3 Mike 10000
4 rAj 1500
------------------------------------

Hope this is clear !

S.Vinothkumar · #3 (**permalink**) 08-07-2007, 05:24 AM

BETWEEN supplies a range of values while IN supplies a list of values.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What is the length(picture clause)?	S.Vinothkumar	Database Support	1	10-30-2007 01:17 AM
finally clause of a try-catch-finally statement	vigneshgets	Java Programming	2	08-16-2007 07:35 AM
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE in SQL Server?	mobilegeek	Database Support	2	08-07-2007 08:04 AM
If I return out of a try/finally in C#, does the code in the finally-clause run?	H2o	C# Programming	1	07-22-2007 11:27 PM