select d7,a.[no],d1,d7,c_type,d8,d9 from c a inner join menu b on b.d0=a.sn where a.t_sn=@t_sn order by d1 offset (0) rows fetch next 30 rows only option (fast 1)