일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
- github
- MSSQL
- 백준
- anaconda3
- HTML
- python 3.7
- 델파이
- delphi 10.3
- pyhcarm
- python3
- 중복제거
- c#
- TMS
- GIT
- templates
- hackerrank
- COMMIT
- advColumnGrid
- blog
- Visual Studio
- PyCharm
- pythonanywhere
- declare
- Django
- dbadvgrid
- Push
- get_object_or_404
- queryset
- rank
- Delphi
- Today
- Total
목록중복제거 (2)
DevHyun
www.hackerrank.com/domains/sql Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. For example, if there are three records in the table with CITY values 'New York', 'New York', 'Bengalaru', there are 2 dif..
www.hackerrank.com/domains/sql Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 짧은 영어실력으로 번역하자면.. STATION 테이블의 CITY 필드를 추출해 내는 것이 목표이고, 조건은 ID가 EVEN(짝수) 일 것. 정렬 순서는 상관없고 중복제거 MSS..