getting a specific value on table

[mohamed_ahid]

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

[ashfaq_haseeb]

Hi,

Have a look at firstsortedvalue() function.

Can you post sample data.

Regards

ASHFAQ

[mohamed_ahid]

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   

[tresB · Accepted solution]

Like attached sample?

[mohamed_ahid]

Thanx everybody it works with tresesco's solution.