Help for a difficult random query in MSQL2000 and ASP

[dalir]

hi everyone

please help me about this problem

i have 3 table with this names "DATAS, CATEGORIES, CHANNELS"
my database is SQLSERVER 2000

i like to select 30 records from DATAS table randomly with this lows :
10 record randomy form datas where datas.s=1
10 record randomy form datas where datas.s=2
10 record randomy form datas where datas.s=3
and like to view these records order by datas.s ASC

can anybody help ?