求SQL过虑过分组数据
PsotionLevel DeptID PositionID
4 A38A556D-0413-445D-8AEB-618B8B94AE15 92C2AF0D-A859-4E91-A67D-569F3595B9EE
4 5FF6EEAA-C2DA-40C1-956E-8782496B2560 B941CAD1-FB88-43E0-B4FA-A7F888CB955D
5 5FF6EEAA-C2DA-40C1-956E-8782496B2560 ED64A7F3-80CA-48A7-B5F8-A5D3300CB018
6 5FF6EEAA-C2DA-40C1-956E-8782496B2560 BA2BA2AC-B7FE-4EB4-9E5D-D40E07F05821
7 46B8C7E1-8D52-4556-AF4C-1E1A0D37DAFD 3CC20660-2D5B-461B-859E-425D780F29B2
需要过虑部门一样的数据,保留PositionLevel最大的一条以及其他数据。
结果:
PsotionLevel DeptID PositionID
4 A38A556D-0413-445D-8AEB-618B8B94AE15 92C2AF0D-A859-4E91-A67D-569F3595B9EE
6 5FF6EEAA-C2DA-40C1-956E-8782496B2560 BA2BA2AC-B7FE-4EB4-9E5D-D40E07F05821
7 46B8C7E1-8D52-4556-AF4C-1E1A0D37DAFD 3CC20660-2D5B-461B-859E-425D780F29B2