摘要：--方法一： select a.id,a.SName,a.ClsNo,a.Score from Table1 a left join Table1 b on a.ClsNo=b.ClsNo and a.Score(select count(*) from Table1 where ClsNo=a.ClsNo and Score>a.Score) order by a.ClsNo... 阅读全文

摘要：delete from test1 where (id,name )in (select * from ( select id,name from test1 group by id,name having (count(*)>1) ) a) and num not in(select * from ( select min(num) from t... 阅读全文

摘要：1 --创建表空间 2 create tablespace tablespace_name 3 innodb and ndb: 4 add datafile 'file_name' 5 innodb only: 6 [file_block_size = value] 7 ndb only: 8 use logfile... 阅读全文