Skip to content

Latest commit

 

History

History
38 lines (29 loc) · 1.1 KB

README.md

File metadata and controls

38 lines (29 loc) · 1.1 KB
Raw

sql-advance

select CITY, length( CITY ) from STATION where length( CITY ) = ( select min( length( CITY ) ) from station ) order by CITY limit 1;

select CITY, length( CITY ) from STATION where length( CITY ) = ( select max( length( CITY ) ) from station ) order by CITY limit 1;

select CITY, length( CITY ) from STATION where id = ( select id from STATION order by length(CITY) desc limit 1 );

select CITY, length( CITY ) from STATION where id = ( select id from STATION where length(city) = (select min(length(city)) from station) order by CITY limit 1; limit 1 );

SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[aeiou]'; SELECT DISTINCT CITY FROM STATION WHERE CITY regexp '.[aeiouAEIOU]$'; SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[aeiou].*[aeiou]$'; SELECT DISTINCT CITY FROM STATION WHERE CITY NOT RLIKE '^[aeiou]'; SELECT DISTINCT CITY FROM STATION WHERE CITY not rlike '.[aeiouAEIOU]$'; SELECT DISTINCT CITY FROM STATION WHERE CITY NOT RLIKE '^[aeiou]' || CITY not rlike '.[aeiouAEIOU]$';

https://nifannn.github.io/2017/10/24/SQL-Notes-Hackerrank-Challenges/