解决方案 »
- 这行代码,列名加不加引号,区别在哪里呢?
- SQL2005备份与还原问题
- 又是新手的存储过程问题~~~~~~~
- 求助 一个简单的SQL-server2000语句问题?
- 帮小妹一把,求一SQL,请大家帮忙,找出树的叶子结点????在线等,解决立结贴
- Reporting Services配置管理器问题
- 求一sql语句
- sql server configuration manager 打不开
- 怎么在SQL2005中,将IP地址(存为varchar(200))转换成整型???
- 求教----动态的取得表的后缀
- sql 中distinct 用法求解答
- SQL Server 正则表达式 无法作用于SQL_MODULES 中的Definition字段
from RZ_ExamineePK a
where exists (select 1 from (select max(Score) as Score,Province from RZ_ExamineePK
group by Province)b where a.score=b.score and a.province=b.province)
select b.id,a.* from (
select max(Score) as Score,Province from RZ_ExamineePK
group by Province
) a
left join RZ_ExamineePK b on a.score=b.score and a.Province=b.Province
工具格式化是这样的
SELECT *
FROM RZ_ExamineePK a
WHERE EXISTS ( SELECT 1
FROM ( SELECT MAX(Score) AS Score ,
Province
FROM RZ_ExamineePK
GROUP BY Province
) b
WHERE a.score = b.score
AND a.province = b.province )