We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
In Oracle SQL Developer m writing with below query but it's not working. Can someone please help!
WITH MAXCITY AS
(SELECT CITY,LENGTH(CITY) FROM STATION
WHERE LENGTH(CITY)=(SELECT MAX(LENGTH(CITY)) FROM STATION)
ORDER BY CITY DESC
FETCH FIRST 1 ROW ONLY
),
MINCITY AS
(SELECT CITY,LENGTH(CITY) FROM STATION
WHERE LENGTH(CITY)=(SELECT MIN(LENGTH(CITY)) FROM STATION)
ORDER BY CITY DESC
FETCH FIRST 1 ROW ONLY
)
SELECT CITY AS CITY,LENGTH(CITY) AS CITYLENGTH
FROM MAXCITY
UNION
SELECT CITY AS CITY,LENGTH(CITY) AS CITYLENGTH
FROM MINCITY;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
In Oracle SQL Developer m writing with below query but it's not working. Can someone please help! WITH MAXCITY AS (SELECT CITY,LENGTH(CITY) FROM STATION WHERE LENGTH(CITY)=(SELECT MAX(LENGTH(CITY)) FROM STATION) ORDER BY CITY DESC FETCH FIRST 1 ROW ONLY ), MINCITY AS (SELECT CITY,LENGTH(CITY) FROM STATION WHERE LENGTH(CITY)=(SELECT MIN(LENGTH(CITY)) FROM STATION) ORDER BY CITY DESC FETCH FIRST 1 ROW ONLY ) SELECT CITY AS CITY,LENGTH(CITY) AS CITYLENGTH FROM MAXCITY UNION SELECT CITY AS CITY,LENGTH(CITY) AS CITYLENGTH FROM MINCITY;