且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

sql server从组中选择第一行

更新时间:2023-02-05 17:35:28

如果按照您的指示,顺序无关紧要,任何 聚合函数 b 就足够了.

If as you indicated, order doesn't matter, any aggregate function on b would be sufficient.

SELECT a, b = MIN(b)
FROM   YourTable
GROUP BY
       a