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

 
[sqlite] [sqlite] Sorting, Grouping and Compound SELECTs
 작성자 : rootman
Date : 2011-10-28 11:38  |  Hit : 4,962  


When query results are sorted by an ORDER BY clause, values with storage class NULL come first, followed by INTEGER and REAL values interspersed in numeric order, followed by TEXT values in collating sequence order, and finally BLOB values in memcmp() order. No storage class conversions occur before the sort.

When grouping values with the GROUP BY clause values with different storage classes are considered distinct, except for INTEGER and REAL values which are considered equal if they are numerically equal. No affinities are applied to any values as the result of a GROUP by clause.

The compound SELECT operators UNION, INTERSECT and EXCEPT perform implicit comparisons between values. No affinity is applied to comparison operands for the implicit comparisons associated with UNION, INTERSECT, or EXCEPT - the values are compared as is.


 
 

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