select query with between operator

Select query with between Operator

SELECT columnname FROM tablename WHERE columnname BETWEEN value1 AND value2;

find the value in the particular range from the table

Example

select * from employee where salary between 10000 and 20000

find all the employee whose salary lie between 10000 to 20000


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.