![[해커랭크] MySQL concat 구문 - The PADS](http://img1.daumcdn.net/thumb/R800x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FRoPg2%2FbtstMALtjmo%2FaduRSkknCYoSlf0f7mFSok%2Fimg.png "[해커랭크] MySQL concat 구문 - The PADS")
The PADS | HackerRank Query the name and abbreviated occupation for each person in OCCUPATIONS. www.hackerrank.com 해커랭크에서 처음 만나는 Medium 난이도의 문제였습니다. 크게 어려운 부분은 없긴했지만 union을 사용하다가 오래 걸렸네요..(사실 union을 사용할 필요는 없었습니다) 이번 해커랭크 문제는 2개의 문제가 주어졌습니다. 문제) Generate the following two result sets: 1. Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of..
원문링크 : [해커랭크] MySQL concat 구문 - The PADS
![파이어족 무엇일까? [파이어족이 온다]를 읽고나서.](http://img1.daumcdn.net/thumb/R800x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FEAvjg%2FbtqU93v1PO0%2FD1WUd9QUVOcPxGAaSC2YzK%2Fimg.jpg "파이어족 무엇일까? [파이어족이 온다]를 읽고나서.")
![[해커랭크] MySQL 정규표현식 - Weather Observation Station 9](http://img1.daumcdn.net/thumb/R800x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FXqweP%2FbtstzvwTKvI%2FaE1NjY9YoSj3rVTsrG1VL1%2Fimg.jpg "[해커랭크] MySQL 정규표현식 - Weather Observation Station 9")
![[해커랭크] MySQL 숫자를 문자로 변환하기(CAST) - The Blunder](http://img1.daumcdn.net/thumb/R800x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2Fcr1j6j%2FbtstMixpQ6X%2FST4CguAVsDwxMWEHvRq171%2Fimg.png "[해커랭크] MySQL 숫자를 문자로 변환하기(CAST) - The Blunder")
![[해커랭크] MySQL 서브쿼리 - Top Competitors](http://img1.daumcdn.net/thumb/R800x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2Fyd4Pv%2FbtstXBcQ00m%2FM3GdgqgWkejwJBzKTJiSlk%2Fimg.png "[해커랭크] MySQL 서브쿼리 - Top Competitors")
네이버 블로그
티스토리
커뮤니티