android sqlite3 adb命令学习(6)

    -- Text comparison is performed using the BINARY collation sequence.
    SELECT (a = b) FROM t1;

    -- Text comparison is performed using the NOCASE collation sequence.
    SELECT (d = a) FROM t1;

    -- Text comparison is performed using the BINARY collation sequence.
    SELECT (a = d) FROM t1;

    -- Text comparison is performed using the REVERSE collation sequence.
    SELECT ('abc' = c) FROM t1;

    -- Text comparison is performed using the REVERSE collation sequence.
    SELECT (c = 'abc') FROM t1;

    -- Grouping is performed using the NOCASE collation sequence (i.e. values

    -- 'abc' and 'ABC' are placed in the same group).
    SELECT count(*) GROUP BY d FROM t1;

    -- Grouping is performed using the BINARY collation sequence.
    SELECT count(*) GROUP BY (d || '') FROM t1;

    -- Sorting is performed using the REVERSE collation sequence.
    SELECT * FROM t1 ORDER BY c;

    -- Sorting is performed using the BINARY collation sequence.
    SELECT * FROM t1 ORDER BY (c || '');

    -- Sorting is performed using the NOCASE collation sequence.
    SELECT * FROM t1 ORDER BY c COLLATE NOCASE;