select * from Test_table select Çб³ from Test_table where Name='¸í¿ù' select * from Test_table where Çб³ = (select Çб³ from Test_table where Name='¸í¿ù') select Çб³ from Test_table where Çгâ='2' select * from Test_table where Çб³ = ANY(select Çб³ from Test_table where Çгâ='2') select * from Test_table order by idx desc select * from Test_table order by Çгâ asc select distinct Çб³ from Test_table select top 3 * from Test_table order by idx desc select * from Test_table tablesample (50 percent) select top (select count (*) / 5 from Test_table) * from Test_table order by idx asc select top (20)percent * from Test_table order by idx asc