Home » RDBMS Server » Server Administration » Re: Finding maximum 3 rows
Re: Finding maximum 3 rows [message #371452] Fri, 20 October 2000 19:18
LUNA
Messages: 4
Registered: October 2000
Junior Member
select length(COUNTRY_NAME) LONGITUD ,COUNTRY_NAME
from COUNTRY
where rownum<4
order by LONGITUD

Report message to a moderator

Previous Topic: Command
Next Topic: Dynamic SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 15:52:37 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.