
Untitled
By: a guest on
May 7th, 2012 | syntax:
None | size: 0.63 KB | hits: 12 | expires: Never
Selecting and ordering by two fields
"SELECT * FROM bookmarks WHERE id=? ORDER BY title ASC",
"SELECT * FROM bookmarks WHERE id=? ORDER BY title ASC AND ORDER BY tag ASC",
SELECT * FROM bookmarks WHERE id=? ORDER BY tag, title;
SELECT * FROM bookmarks WHERE id=? ORDER BY tag ASC, title ASC
SELECT * FROM bookmarks WHERE id=? ORDER BY tag ASC, title ASC;
SELECT * FROM t1
ORDER BY key_part1,key_part2,... ;
SELECT * FROM t1
WHERE key_part1=constant
ORDER BY key_part2;
SELECT * FROM t1
ORDER BY key_part1 DESC, key_part2 DESC;
SELECT * FROM t1
WHERE key_part1=1
ORDER BY key_part1 DESC, key_part2 DESC;