PostgreSQL 9.6.0 锟街诧拷
锟斤拷一页	锟斤拷一锟斤拷	锟斤拷 11. 锟斤拷锟斤拷	锟斤拷一页

11.4. 锟斤拷锟斤拷锟斤拷`ORDER BY`

锟斤拷锟剿简单地诧拷锟揭诧拷询要锟斤拷锟截碉拷锟斤拷锟解，一锟斤拷锟斤拷锟斤拷锟斤拷锟杰伙拷锟斤拷要锟斤拷锟斤拷锟斤拷锟斤拷指锟斤拷锟斤拷顺锟津传递★拷锟斤拷使锟矫诧拷询锟叫碉拷ORDER BY锟斤拷锟斤拷要锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟借。锟斤拷PostgreSQL锟斤拷前支锟街碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫ｏ拷只锟斤拷B-tree锟斤拷锟皆诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷突锟斤拷锟斤拷锟斤拷一锟斤拷没锟斤拷指锟斤拷锟斤拷锟斤拷锟斤拷实锟斤拷锟斤拷氐锟剿筹拷蚍祷亍锟�

锟芥划锟斤拷锟结考锟斤拷锟斤拷锟斤拷锟街凤拷式锟斤拷锟斤拷锟斤拷一锟斤拷ORDER BY说锟斤拷锟斤拷扫锟斤拷一锟斤拷锟斤拷锟斤拷说锟斤拷锟侥匡拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷顺锟斤拷扫锟斤拷锟饺伙拷锟斤拷锟斤拷锟绞斤拷锟斤拷颉６锟斤拷锟揭伙拷锟斤拷锟揭拷锟斤拷锟侥大部分的诧拷询锟斤拷一锟斤拷锟斤拷式锟斤拷锟斤拷锟斤拷芸锟斤拷鼙锟绞癸拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷欤拷锟轿拷锟剿筹拷锟斤拷锟斤拷模式使锟斤拷锟斤拷锟斤拷锟斤拷要锟侥达拷锟斤拷I/O锟斤拷锟劫★拷只锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷要锟斤拷取锟斤拷时锟斤拷锟斤拷锟斤拷锟脚伙拷锟斤拷锟斤拷谩锟揭伙拷锟斤拷锟揭拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷ORDER BY锟斤拷LIMIT n锟斤拷锟斤拷使锟矫ｏ拷一锟斤拷锟斤拷式锟斤拷锟斤拷锟津将会处锟斤拷锟斤拷锟叫碉拷锟斤拷锟斤拷锟斤拷确锟斤拷锟斤拷前锟斤拷锟�n锟叫ｏ拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟�ORDER BY锟斤拷锟斤拷锟斤拷锟斤拷前n锟叫斤拷锟结被直锟接伙拷取锟揭革拷锟斤拷锟斤拷锟斤拷要扫锟斤拷剩锟铰碉拷锟斤拷锟捷★拷

默锟斤拷锟斤拷锟斤拷拢锟紹-tree锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷式锟芥储锟斤拷锟斤拷锟斤拷锟斤拷值锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿讹拷哦锟斤拷锟�x锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷前锟斤拷扫锟借将锟斤拷锟斤拷锟斤拷锟斤拷ORDER BY x锟斤拷锟斤拷锟竭革拷锟斤拷锟斤拷锟斤拷式锟斤拷ORDER BY x ASC NULLS LAST锟斤拷锟侥斤拷锟斤拷锟斤拷锟斤拷锟揭诧拷锟斤拷员锟斤拷锟斤拷锟缴拷瑁拷锟斤拷锟斤拷锟斤拷锟�ORDER BY x DESC锟斤拷ORDER BY x DESC NULLS FIRST锟斤拷 NULLS FIRST锟斤拷ORDER BY DESC锟斤拷默锟斤拷锟斤拷锟斤拷锟斤拷锟�

锟斤拷锟角匡拷锟斤拷锟节达拷锟斤拷B-tree锟斤拷锟斤拷时通锟斤拷ASC锟斤拷DESC锟斤拷NULLS FIRST锟斤拷NULLS LAST选锟斤拷锟斤拷锟侥憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟界：

CREATE INDEX test2_info_nulls_low ON test2 (info NULLS FIRST);
CREATE INDEX test3_desc_index ON test3 (id DESC NULLS LAST);

一锟斤拷锟斤拷锟斤拷锟斤拷娲拷医锟斤拷锟街登帮拷玫锟斤拷锟斤拷锟斤拷锟斤拷愿锟斤拷锟缴拷璺斤拷锟斤拷锟街э拷锟�ORDER BY x ASC NULLS FIRST锟斤拷 ORDER BY x DESC NULLS LAST锟斤拷

锟斤拷锟竭匡拷锟杰伙拷锟缴伙拷为什么要锟介烦锟斤拷锟结供锟斤拷锟斤拷锟侥革拷选锟筋，锟斤拷为锟斤拷锟斤拷选锟斤拷锟斤拷同锟斤拷锟斤拷扫锟斤拷母锟斤拷士锟斤拷愿锟斤拷锟斤拷锟斤拷锟�ORDER BY锟侥憋拷锟藉。锟节碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷些选锟斤拷确实锟斤拷锟斤拷锟洁，锟斤拷锟斤拷锟节讹拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷却锟斤拷锟斤拷锟矫★拷锟斤拷锟斤拷(x, y)锟较碉拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷通锟斤拷前锟斤拷扫锟斤拷锟斤拷锟斤拷ORDER BY x, y锟斤拷锟斤拷锟斤拷通锟斤拷锟斤拷锟斤拷扫锟斤拷锟斤拷锟斤拷ORDER BY x DESC, y DESC锟斤拷锟斤拷锟斤拷应锟矫匡拷锟斤拷锟斤拷要频锟斤拷锟斤拷使锟斤拷ORDER BY x ASC, y DESC锟斤拷锟斤拷锟斤拷锟斤拷没锟叫办法锟斤拷通锟斤拷锟斤拷锟斤拷锟斤拷锟叫得碉拷锟斤拷锟斤拷顺锟津，碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿�(x ASC, y DESC)锟斤拷锟斤拷(x DESC, y ASC)锟酵匡拷锟皆诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷

锟斤拷然锟斤拷锟斤拷锟叫凤拷默锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷嗟弊拷诺锟斤拷锟斤拷裕锟斤拷锟斤拷锟斤拷锟绞憋拷锟斤拷腔锟轿拷囟锟斤拷锟窖拷峁╋拷薮锟斤拷锟劫讹拷锟斤拷锟斤拷锟斤拷锟角凤拷值锟斤拷维锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷取锟斤拷锟斤拷锟斤拷锟角伙拷锟狡碉拷锟斤拷锟绞癸拷锟斤拷锟揭拷锟斤拷锟斤拷锟斤拷锟侥诧拷询锟斤拷

锟斤拷一页	锟斤拷始页	锟斤拷一页
锟斤拷锟斤拷锟斤拷锟斤拷	锟斤拷一锟斤拷	锟斤拷隙锟斤拷锟斤拷锟斤拷

11.4. 锟斤拷锟斤拷锟斤拷ORDER BY

11.4. 锟斤拷锟斤拷锟斤拷`ORDER BY`