求一个简单的SQL语句!!!!!!!!!!!!!!!

[iamwiner]

表:Test(Pid,Name)
求按Pid排序后,第10到19行Name的SQL语句

[lsxaa]

select * from test a
where (select count(*) from test where pid<=a.pid) in(10,19)

[iamwiner]

一个字:强!