Saturday, June 4, 2016

SQL oracle




select * from (
select city,length(city)
from station
where length(city) = (select min(length(city)) from station)
order by city)
where rownum = 1;

select * from (
select city,length(city)
from station
where length(city) = (select max(length(city)) from station)
order by city)
where rownum = 1;

No comments:

Post a Comment