Give a range in a query

[buterfly0707]

hi..

i want to kow wether can we give a range in sql.
maens i want to get the values in field where one period to another period.
example:ther is two fields in the table period and data. i want to get all the values in data field acccording to given period value (like 1 to 3) how can i do this??

thank you in advance

[nbiswas]

Solution to Give a range in a query

Are you looking for this

Sample data

declare @t table(period int, data varchar(20))
insert into @t 
	select 1,'data1' union all select 2,'data2' union all 
	select 3,'data3' union all select 4,'data4' union all 
	select 5,'data5' union all select 6,'data6' union all 
	select 7,'data7' union all select 8,'data8' union all 
	select 9,'data9' union all select 10,'data10' 
select * from @t

Query 1:

select data from @t where period between 1 and 3

Query 2:

select data from @t where period>= 1 and period<=3

Output:

data

data1
data2
data3

I am selecting data between the period 1 & 3

Hope this helps.

[buterfly0707]

thank you it worked nicely.