Notice
Recent Posts
Recent Comments
Link
| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 |
Tags
- hackerrank
- Django
- rank
- Delphi
- templates
- 중복제거
- delphi 10.3
- GIT
- advColumnGrid
- anaconda3
- github
- 백준
- blog
- declare
- COMMIT
- MSSQL
- get_object_or_404
- queryset
- Visual Studio
- dbadvgrid
- python3
- TMS
- PyCharm
- pythonanywhere
- pyhcarm
- 델파이
- Push
- python 3.7
- HTML
- c#
Archives
- Today
- Total
목록pivot (1)
DevHyun
Occupations
www.hackerrank.com/domains/sql Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output column headers should be Doctor, Professor, Singer, and Actor, respectively. Note: Print NULL when there are no more names corresponding to an occupation. Input Format The OCCUPATIONS table is described as follows: ..
SQL/HACKERRANK
2020. 11. 3. 15:20