Sql 表查询 6-10

select * from t_Student where S_sex like '[女]' and S_class = 95031

select * from t_Student order by S_class desc

select * from t_Score order by C_no asc
select * from t_Score order by S_chengji desc

select * from t_Student where S_class = 95031

select top 1 * from t_Score order by S_chengji desc

posted @ 2015-08-23 17:10  地狱猫  阅读(164)  评论(0编辑  收藏  举报