ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[¤À¨É] NULL­È±Æ§Ç¤è¦¡

ORDER BY col DESC NULLS FIRST --NULL­È±Æ¦b³Ì«e­± ¨ä¥L¼Æ­È¥¿¦V±Æ¦C
ORDER BY col ASC NULLS FIRST --NU ...
Min µoªí©ó 2010-5-9 20:52



    ½Ð°Ý¤p¶{ª©¥D
¦pªG¥t¥~¦Û³]¥["is not null"±ø¥ó¡A¹F¨ì¨Ï¥Î(ORDER BY)  Indexªº­n¨D¡K¡K
¬O§_¥i¥H©¿²¤
ORDER BY col DESC NULLS FIRST --NULL­È±Æ¦b³Ì«e­± ¨ä¥L¼Æ­È¥¿¦V±Æ¦C
ORDER BY col ASC NULLS FIRST --NULL­È±Æ¦b³Ì«e­± ¨ä¥L¼Æ­È¤Ï¦V±Æ¦C
¥¿¤Ï¦V(¤É§Ç©Î­°§Ç±Æ¦C)?
ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD