[SQL] howto?

iations round but I can't figure out how to do this. Any suggestions??     greetz sjors

Re: [SQL] howto/min values

    from table as p1                             where p.points=p1points) order by points, id  This of course doesn't work, because of the referring to the calculated field wich is not actually a part of the table. Can you do this somehow or is it impossible? Love to hear from you guys,   greetz Sjors