LyndonOHRC
Programmer
I have the query below that selects the correct data. We need to modify it for another output and it's beyond my skill level.
This time I need to group it by License.AssignedAgent and only pull the "Top 50" of each group. Also, the "Order By" clause I'm using is important within each group; we need to see the newest Applications.ApplicationYear's first.
Any help much appreciated. Lyndon
Lyndon
This time I need to group it by License.AssignedAgent and only pull the "Top 50" of each group. Also, the "Order By" clause I'm using is important within each group; we need to see the newest Applications.ApplicationYear's first.
Any help much appreciated. Lyndon
Code:
Select License.*, Applications.ApplicationYear
From License, Applications
Where License.ID=Applications.MasterID
And License.Status='P'
Order By License.AssignedAgent, Applications.ApplicationYear, License.LastName, License.FirstName
Lyndon