3条回答 默认 最新
- 擎一天 2017-10-26 08:07关注
套一层就好了。何必纠结。
SELECT * FROM (SELECT USERID,DEPT,SALARY,MIN(SALARY) OVER(PARTITION BY DEPT) SALARY2 FROM DEPT) XX ORDER BY XX.USERID本回答被题主选为最佳回答 , 对您是否有帮助呢?解决评论 打赏 举报无用 2
套一层就好了。何必纠结。
SELECT * FROM (SELECT USERID,DEPT,SALARY,MIN(SALARY) OVER(PARTITION BY DEPT) SALARY2 FROM DEPT) XX ORDER BY XX.USERID