Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all ,
i'm trying to get a specific value for a customer in a table .
In my deal table every customer have no deal or several deal .for those having several deals i'm tryin to have the first , second and third deal's date .
how can i do that ?
thx
Like attached sample?
Hi,
Have a look at firstsortedvalue() function.
Can you post sample data.
Regards
ASHFAQ
Thanx Mohammed,
for my order data it schould be like this
ID, OrderDate
1, 12/12/2013
1, 13/12/2013
1, 18/12/2013
1, 28/12/2013
1, 23/12/2013
1, 22/12/2013
2, 06/08/2013
2, 09/08/2013
2, 04/09/2013
3, 01/11/2013
3, 23/11/2013
3, 29/11/2013
3, 17/11/2013
3, 20/11/2013
I want to get for every ID the first , seconde and third order date like this :
ID First Order seconde Order third order
1 12/12/2013 13/12/2013 18/12/2013
2 06/08/2013 09/08/2013 04/09/2013
3 01/11/2013 07/11/2013 20/11/2013
Like attached sample?
Thanx everybody it works with tresesco's solution.