Skip to Content
0

FIRST_VALUE Function

May 15, 2017 at 04:45 PM

28

avatar image

Hi Experts,

In the next Business Partners query I need to add a filed for the date of the first invoice in the history of each BP.

I tried with FIRST_VALUE Function and with TOP 1 Function too, but i got so many errors.

Can you help me please.

SELECT T0."CardCode" ,T0."CardName" ,T1."GroupName" ,T2."SlpName" ,T3."ListName" FROM "PAF_LIVE"."OCRD" T0 INNER JOIN "PAF_LIVE"."OCRG" T1 ON T0."GroupCode" = T1."GroupCode" INNER JOIN "PAF_LIVE"."OSLP" T2 ON T0."SlpCode" = T2."SlpCode" INNER JOIN OPLN T3 ON T0."ListNum" = T3."ListNum" WHERE T0."CardType" = 'C' ORDER BY T0."CardCode"

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers