I can't find how to solve one question. I have list of ClientID, also i have a list of agreement dates.
CLIENT_ID AGREEMENT_DATE
1 01/03/2012
2 01/05/2013
5 11/10/2013
3 01/06/2014
5 06/08/2015
i need to find out how many agreements had a single Client? and if there are several agreements i need to show which was first, second and so on.
As a result i would have:
ClientID CountOfAgreements
5 2
1 1
2 1
3 1
than:
ClientID AgreementOrder
5 11/10/2013
5 06/08/2015
CLIENT_ID AGREEMENT_DATE
1 01/03/2012
2 01/05/2013
5 11/10/2013
3 01/06/2014
5 06/08/2015
i need to find out how many agreements had a single Client? and if there are several agreements i need to show which was first, second and so on.
As a result i would have:
ClientID CountOfAgreements
5 2
1 1
2 1
3 1
than:
ClientID AgreementOrder
5 11/10/2013
5 06/08/2015