近期在整理某数据时 涉及到一个疑难点，琢磨很久后还不得其所
让我想破了脑壳 终于找到了几个办法
Table1DepNameAtomAjohnAmaryBlongmanBsolongCtomyClincon
SELECT b.Dep , b.Name , (select count(*) from Table1 a where a.dep=b.dep and a.name<=b.name) AS id
FROM Table1 AS b
ORDER BY b.Dep, b.Name;
*Count(*) ,Sum(1)效果一样
Query1DepNameidAjohn1Amary2Atom3Blongman1Bsolong2Clincon1Ctomy2
Oracle:
select T.*, rank()over(partition by DEPT order by NAME desc)
from Table1 t