Home » RDBMS Server » Server Administration » Re: Help on SQL "SELECT.."
Re: Help on SQL "SELECT.." [message #371011] Tue, 08 August 2000 03:59
David
Messages: 110
Registered: November 1998
Senior Member
try this ...

select * from table -- insert correct table name
where rownum < 2 -- limit returns to one row
order by number desc -- highest number at top
Previous Topic: DB Link
Next Topic: Top N values
Goto Forum:
  


Current Time: Fri Mar 29 09:51:32 CDT 2024