jayeshp100

does any one know how display the top 10 rows of query, ive tried to use the rank function but can get it work.select sum(d.price), e.Title, d.dvd_id from dvd_rental d, dvd_details e where ORDER_DATE between '4-NOV-04' and '04-NOV-05' and e.dvd_id = d.dvd_id group by d.dvd_id, e.title order by sum(d.price) desc /here's a query ive created, this displays the DVDs making the most money, how do i display just the top 10 rows by price.any ideas