計算排名

WITH Employees AS(SELECT 'Isabella' as name, 2 as department, DATE(1997, 09, 28) as start_dateUNION ALL SELECT 'Anthony', 1, DATE(1995, 11, 29)UNION ALL SELECT 'Daniel', 2, DATE(2004, 06, 24)UNION ALL SELECT 'Andrew', 1, DATE(1999, 01, 23)UNION ALL SELECT 'Jacob', 1, DATE(1990, 07, 11)UNION ALL SELECT 'Jose', 2, DATE(2013, 03, 17))SELECT name, department, start_date,RANK() OVER (PARTITION BY department ORDER BY start_date) AS rank FROM Employees;

總結

以上是生活随笔為你收集整理的sql 精读(7)的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。