Showing posts with label SQL IN Between operator. Show all posts
Showing posts with label SQL IN Between operator. Show all posts

Saturday, 19 July 2014

SQL IN Between operator

SQL IN operator
EX: select * from <Table> where EName in ('Microsoft', 'India')
Between Operator
Ex: select * from <Table> where EID between 100 and 150
Ex: select * from <Table> where EID between '22/12/2010' and '22/12/2011'
Ex: select * from <Table> where EID between 'A' and 'E'