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: Sat Apr 27 08:42:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.