摘要:
select name from tablename group by name having min(fenshu)>80 或者 select distinct name from tablename where name not in (select distinct name from tab 阅读全文
摘要:
using System; using System.Collections; using System.Collections.Specialized; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Data.Common; using System.Collec... 阅读全文
摘要:
select count(case 分数字段 when 100 then 1 end) as [满分],count(case when 分数字段 between 90 and 99 then 1 end) as[90-99分],count(case when 分数字段 between 80 and 阅读全文