리눅스, 자료실, 성경검색, 추억의게임, 고전게임, 오락실게임, rootman, http://www.rootman.co.kr
* 3.214.184.250 *
| Home | Profile | Linux | 자료실 | zabbix | Mysql 5.6 | 갤러리 | 성경검색 | 해피니스 | 자유게시판 | 게시물검색 | L | O | R |    

 
[sqlite] [sqlite] Collation Sequence Examples
 작성자 : rootman
Date : 2011-10-28 11:41  |  Hit : 4,608  

The examples below identify the collating sequences that would be used to determine the results of text comparisons that may be performed by various SQL statements. Note that a text comparison may not be required, and no collating sequence used, in the case of numeric, blob or NULL values.

CREATE TABLE t1(
x INTEGER PRIMARY KEY,
a,
SELECT x FROM t1 WHERE a = b ORDER BY x;
--result 1 2 3


SELECT x FROM t1 WHERE a = b COLLATE RTRIM ORDER BY x;
--result 1 2 3 4


SELECT x FROM t1 WHERE d = a ORDER BY x;
--result 1 2 3 4


SELECT x FROM t1 WHERE a = d ORDER BY x;
--result 1 4


SELECT x FROM t1 WHERE 'abc' = c ORDER BY x;
--result 1 2 3


SELECT x FROM t1 WHERE c = 'abc' ORDER BY x;
--result 1 2 3


SELECT count(*) FROM t1 GROUP BY d ORDER BY 1;
--result 4


SELECT count(*) FROM t1 GROUP BY (d || '') ORDER BY 1;
--result 1 1 2


SELECT x FROM t1 ORDER BY c, x;
--result 4 1 2 3


SELECT x FROM t1 ORDER BY (c||''), x;
--result 4 2 3 1


SELECT x FROM t1 ORDER BY c COLLATE NOCASE, x;
--result 2 4 3 1


 
 

Total. 19
번호 분류 제목 작성자 등록일 조회수
19 sqlite [sqlite3] 날짜와 시간 함수 알아보기 rootman 12-14 10571
18 sqlite [sqlite3] command, DB 전체를 dump export, dump import 하기 rootman 12-12 5035
17 sqlite [sqlite3] command, 외부로 import/export하기 rootman 12-12 4633
16 sqlite [sqlite] 유용한 함수들 rootman 11-22 6987
15 sqlite [sqlite] 반올림, 버림, 올림 함수 rootman 11-22 10782
14 sqlite [sqlite] I deleted a lot of data but the database file did n… rootman 10-28 4365
13 sqlite [sqlite] How do I add or delete columns from an existing tab… rootman 10-28 4353
12 sqlite [sqlite] Collation Sequence Examples rootman 10-28 4609
11 sqlite [sqlite] Assigning Collating Sequences from SQL rootman 10-28 4435
10 sqlite [sqlite] Collating Sequences rootman 10-28 4265
9 sqlite [sqlite] Sorting, Grouping and Compound SELECTs rootman 10-28 4361
8 sqlite [sqlite] Operators rootman 10-28 4253
7 sqlite [sqlite] Comparison Example rootman 10-28 4377
6 sqlite [sqlite] Type Conversions Prior To Comparison rootman 10-28 4408
5 sqlite [sqlite] Affinity Of Comparison Operands rootman 10-28 4435
 1  2  
AND OR