DevHyun

1 : N의 관계인 테이블 A와 B를 JOIN 할 때, 테이블 B의 데이터는 한개만 가져오고 싶을 때, TABLE_A ( IDX INT, NAME VARCHAR ) TABLE_B ( IDX INT, COUNT INT, SUBJECT VARCHAR ) TABLE_A IDX NAME 1 김철수 2 나영희 3 박소영 TABLE_B IDX COUNT SUBJECT 1 1 국어 1 1 영어 2 5 도덕 3 4 체육 일반적으로 JOIN을 걸게되면 SELECT A.IDX, NAME,COUNT,SUBJECT FROM TABLE_A AS A LEFT JOIN TABLE_B AS B ON A.IDX = B.IDX IDX NAME COUNT SUBJECT 1 김철수 1 국어 1 김철수 1 영어 2 나영희 5 도덕 3 박소영..

www.hackerrank.com/domains/sql Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the west..