Lines Matching refs:BY
5682 ** ORDER BY 1;
5691 ** the DISTINCT and ORDER BY are recommended.
9426 int bDesc; /* True if ORDER BY <expr> DESC */
9438 IdxConstraint *pOrder; /* ORDER BY columns */
9857 /* Add the ORDER BY to the IdxScan object */
10418 IdxConstraint *pTail /* range/ORDER BY constraints for inclusion */
10433 ** range constraint/ORDER BY terms passed in by the caller, if any. */
10436 /* If no range/ORDER BY passed by the caller, create a version of the
10663 "ORDER BY type;";
10768 "ORDER BY 4, 1"
10991 "SELECT %s FROM %Q x ORDER BY %s", zCols, zTab, zOrder
10995 "SELECT %s FROM temp."UNIQUE_TABLE_NAME" x ORDER BY %s", zCols, zOrder
11190 ** collect information regarding the WHERE, ORDER BY and other clauses
13475 ") GROUP BY pgno, cell"
13770 " ORDER BY tbl DESC, name=='sqlite_sequence' DESC"
13775 "WHERE type='table' ORDER BY rowid DESC LIMIT 1"
14287 " ORDER BY (tbl_name='sqlite_sequence') ASC"
16982 "FROM sqlite_schema ORDER BY 2'',224))',\n"
16984 "FROM sqlite_schema ORDER BY 2',224));\n"
16996 " ORDER BY name;\n"
18684 ** "ORDER BY rowid DESC" to the end.
18704 sqlite3_snprintf(len+100, zQ2, "%s ORDER BY rowid DESC", zQuery);
19624 " FROM completion(%Q) ORDER BY 1", text);
19662 " FROM completion(%Q,%Q) ORDER BY 1",
20130 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
20197 " WHERE %s ORDER BY rowid DESC", zWhere);
20729 "GROUP BY s.name, f.id "
20730 "ORDER BY (CASE WHEN ? THEN f.[table] ELSE s.name END)"
21888 " GROUP BY t.cpos"
21908 FROM ColNames ORDER BY cpos\
22454 " ORDER BY tbl_name='sqlite_sequence', rowid",
22737 "ORDER BY x",
24064 " ORDER BY snum, rowid", 0);
24360 "SELECT tno,op,cmd,ans FROM selftest ORDER BY tno",
24489 " ORDER BY 1 collate nocase";
24494 " ORDER BY 1 collate nocase";
24511 " ORDER BY name;", 0);
24514 " ORDER BY name;", 0);
24517 " ORDER BY tbl,idx;", 0);
24521 appendText(&sQuery, " ORDER BY tbl, idx, rowid;\n", 0);
24699 appendText(&s, " ORDER BY 1", 0);