Finding top x percent of data I am trying to do the following w/ SQL for db2 9...
I want to find the top x percent of rows. For example, if i wanted to
find the average sale price of the top 10 most expensive items in a
store, how could I go about doing that, w/o a stored procedure? I've
been searching, and have come across many solutions for other RDBMS,
but not yet for DB2.
Thanks in advance. |