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'