December 22, 1999 09:56 PM
(in response to Tim Lowe)
This is the technique from the query which can give u the top n
FROM T1 A
N > (SELECT COUNT(*)
FROM T1 B
WHERE A.COL1 < B.COL1)
There is one more technique available in QMF i.e by QMF forms u can
limit the no. of rows return and can get the top
"n" or last "n" values.
I hope it helps
"McQuillan, Rory M."
<[login to unmask email]>@RYCI.COM> on 12/22/99
Please respond to DB2 Data Base Discussion List
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
To: [login to unmask email]
Subject: Limiting QMF Query Results
> A common user request is for the top "n" accounts of a
> there an SQL "trick" or some other technique to set the result
> fixed number of rows?