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

Report message to a moderator

Previous Topic: DB Link
Next Topic: Top N values
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 06:43:44 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.