<![CDATA[
<p><b><span style="font-size: 11pt;">SELECT </span></b></p><p style="margin-left: 2em;"><span style="font-size: 11pt;">refined_name,</span></p><p><span style="font-size: 11pt;"> COUNT(*) cnt, </span></p><p><span style="font-size: 11pt;"> RANK() OVER(ORDER BY COUNT(*) desc) rnk </span></p><p style="margin-left: 2em;"><span style="font-size: 11pt;">FROM (</span><span style="font-size: 11pt; font-family: Arial, sans-serif;">SELECT </span></p><p style="margin-left: 6em;"><span style="font-size: 11pt; font-family: Arial, sans-serif;">LOWER(TRIM(SUBSTR(REPLACE(m_name,' ',''),</span></p><p style="margin-left: 2em;"><span style="white-space: pre; font-size: 11pt; font-family: Arial, sans-serif;"> </span> <span style="font-family: Arial, sans-serif; font-size: 11pt;"> </span><span style="font-family: Arial, sans-serif; font-size: 11pt;">I</span><span style="font-size: 11pt; font-family: Arial, sans-serif;"><span style="font-family: Arial, sans-serif;">NS</span>TR(REPLACE(m_name,' ',''),'.')+1,</span><span style="white-space: pre; font-size: 11pt; font-family: Arial, sans-serif;"> </span></p><p style="margin-left: 6em;"><span style="font-size: 11pt; font-family: Arial, sans-serif;">LENGTH(REPLACE(m_name,' ',''))-INSTR(REPLACE(m_name,' ',''),'.')))) as refined_name </span></p><p style="margin-left: 6em;"><span style="font-size: 11pt; font-family: Arial, sans-serif;">FROM music</span><span style="font-size: 11pt;">)</span></p><p><span style="font-size: 11pt;"> </span><b><span style="font-size: 11pt;"> WHERE</span></b><span style="font-size: 11pt;"> refined_name IS NOT NULL AND SUBSTR(refined_name,1,1) != '<'</span></p><p><span style="font-size: 11pt;"> </span><b><span style="font-size: 11pt;">GROUP BY </span></b><span style="font-size: 11pt;">refined_name</span></p><p><span style="font-size: 11pt;"> </span><b><span style="font-size: 11pt;">ORDER BY</span></b><span style="font-size: 11pt;"> cnt desc;</span></p>
<!-- -->
]]>
카페 게시글
1. SQL 수업
Re:CBS 라디오 아침 7시 김용신의 그대와 여는 아침의 음악 선곡은 반복되고 있는가 ?
6기_홍정현
추천 0
조회 55
17.09.20 09:54
댓글 1
다음검색
첫댓글 don't와 don`t 두개가 차이가 있어요.
replace(m_name, CHR(39), '`') 하시면
' (싱글쿼테이션)을 `(어포스트로피) 로 변경가능합니다.
바꿔서 해봤는데 결과값에 차이는 없어요.