1 개요[ | ]
- HR-SQL Weather Observation Station 6
2 DB2[ | ]
sql
3 MS SQL[ | ]
sql
4 MySQL[ | ]
MySQL
Copy
SELECT DISTINCT CITY FROM STATION
WHERE LEFT(CITY,1) IN ('a','e','i','o','u');
MySQL
Copy
SELECT DISTINCT CITY FROM STATION
WHERE MID(CITY,1,1) IN ('a','e','i','o','u');
MySQL
Copy
SELECT CITY FROM STATION
WHERE LEFT(CITY,1) IN ('a','e','i','o','u');
GROUP BY CITY;
MySQL
Copy
SELECT CITY FROM STATION
WHERE MID(CITY,1,1) IN ('a','e','i','o','u');
GROUP BY CITY;
MySQL
Copy
SELECT DISTINCT CITY FROM STATION
WHERE CITY LIKE 'a%'
OR CITY LIKE 'e%'
OR CITY LIKE 'i%'
OR CITY LIKE 'o%'
OR CITY LIKE 'u%';
MySQL
Copy
SELECT CITY FROM STATION
WHERE CITY LIKE 'a%'
OR CITY LIKE 'e%'
OR CITY LIKE 'i%'
OR CITY LIKE 'o%'
OR CITY LIKE 'u%'
GROUP BY CITY;
5 Oracle[ | ]
sql
편집자 Jmnote Jmnote bot
로그인하시면 댓글을 쓸 수 있습니다.