MySQL79 Hacker rank Weather Observation Station 3 1 2 3 select distinct city from station where mod(id,2)=0 cs Line 3 이 프로그래밍언어랑 SQL의 차이죠 Python은 %이 나머지 operator이고 mysql 에서는 mod 함수를 씁니다 ^6^ 2021. 10. 20. Hacker rank Weather Observation Station 1 1 2 select city,state from station cs 2021. 10. 20. Hacker rank Japanese Cities' Names 1 2 3 select name from city where countrycode='JPN' cs 2021. 10. 20. Hacker rank Select By ID 1 2 3 select * from city where id=1661 cs 2021. 10. 20. Hacker rank Select All 1 2 select * from city cs 2021. 10. 20. Hacker rank Revising the Select Query II 1 2 3 select name from city where population >120000 and countrycode='USA' cs 2021. 10. 20. Hackerrank Revising the Select Query I 1 2 3 select * from city where population>100000 and countrycode='USA' cs 2021. 10. 20. 이전 1 ··· 4 5 6 7 다음