Sort and Limit Result

I have a table like this
name char
points number
dicom number
.
.
.

How can i sort the table contents by points and show only the 3 lines with the biggest values?
I have tried the rownum command with order by (select name, points from table where rownum between 1 and 3 order by p desc;) but it's useless it doesn't sort the whole table but only the first (inserted) 3 lines.

any solution?

Thanks in advance Received on Tue Jan 15 2002 - 15:02:17 CST