View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 01:09 PM
nycjay@yahoo.com
 
Posts: n/a
Default 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.
Reply With Quote