Home » RDBMS Server » Server Administration » Re: Finding maximum 3 rows
Re: Finding maximum 3 rows [message #371435] Thu, 19 October 2000 02:47
Sandeep Deshmukh
Messages: 13
Registered: October 2000
Junior Member
select country_name from country a
where 3 > (select count(*) from country
where length(country_name) > length(a.country_name))

Report message to a moderator

Previous Topic: alternate SQL without Exists clause
Next Topic: OLE2
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

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