공부
[Spark] order by 한글 > 영어 > 숫자
승가비
2020. 10. 27. 20:23
728x90
SELECT *
FROM t
ORDER BY
(CASE
WHEN SUBSTRING(name,1,1) RLIKE '[ㄱ-ㅎ가-힣]' THEN 1
WHEN SUBSTRING(name,1,1) RLIKE '[a-zA-Z]' THEN 2
ELSE 3
END),
namehttps://solbel.tistory.com/429
[sql] mysql 데이터 정렬 - 오름차순, 한글-영문-숫자 순서
[sql] mysql 데이터 정렬 - 오름차순, 한글-영문-숫자 순서 * MySQL에서 처리 SELECT * FROM tb_ncc_new_category WHERE service_enable_mobile = 'Y' AND category_type = 'magazine' ORDER BY (CAS..
solbel.tistory.com
https://spark.apache.org/docs/2.3.0/api/sql/#rlike
Functions - Spark SQL, Built-in Functions
Spark SQL, Built-in Functions Docs » Functions ! ! expr - Logical not. % expr1 % expr2 - Returns the remainder after expr1/expr2. Examples: > SELECT 2 % 1.8; 0.2 > SELECT MOD(2, 1.8); 0.2 & expr1 & expr2 - Returns the result of bitwise AND of expr1 and
spark.apache.org
728x90