this sounds as if there must be a rather trivial solution:
i am looking for the 50 rows with the largest value for a particular
column. i could create a view with
create view as select * from table order by column;
and then somehow only retrieve the top 50 rows . . . but how?
thanks
frank