语法:
1 RANK ( )
OVER (
[
< partition_by_clause >
]
< order_by_clause
> )
示例:
1
Select
*
From ElectricBP
2 Where RowID in ( Select RowID From
3 (
4 Select RowID,RANK() Over(PARTITION BY InsureNo Order By OperateTime Desc) As [ RANK ] From ElectricBP
5 ) T Where [ RANK ] = 1)
2 Where RowID in ( Select RowID From
3 (
4 Select RowID,RANK() Over(PARTITION BY InsureNo Order By OperateTime Desc) As [ RANK ] From ElectricBP
5 ) T Where [ RANK ] = 1)