tricky queries

Hello All!
Who knows
how I can Select __five maximal__ or N MAXIMAL values from complex SubQuery.

SELECT ID, DATA FROM (SUBQUERY)
wHERE ID = ( Select MAX( ID ) from (SUBQUERY) )

Returns One MAXIMAL Value, but SubQuery runs Twice! How about FIVE???

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 22 1999 - 08:33:16 CST