SQL Statements

[lusky]

I want to know if it possible to get the 10 biggest accounts by value for each salesman, this is my sql statement: market value(evlmktval)

SELECT
apdadrt.accountnbr,
apdadrt.SALESMAN,
das11.EVLMKTVAL,
das11.accountnbr
FROM
pdata/apdadrt,
pdata/das11
WHERE
APDADRT.ACCOUNTNBR = DAS11.ACCOUNTNBR
order by
APDADRT.SALESMAN,das11.evlmktval DESC

 

[iSeriesCodePoet]

There is an option to select the first 10 records. Off hand I don't remember what the key word is. Mike Wills
AS400 Programmer