On Fri, Oct 29, 1999 at 02:55:29PM +0200, Frank Joerdens allegedly wrote:
> 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
>
> ************
Use limit?
Mathijs