Is there primary key on field Value? Or any index? Daniel
At 14:37 2002.10.04._ +0800, you wrote: > > Hi, > > > > My tables is something like this > > > > Value Count > > B 10 > > C 20 > > A 15 > > D 8 > > > > When I query using "SELECT Value, Count FROM Table", the data is >appearing > > exactly at the order above, however when I select only a single column > > using "SELECT Value FROM Table", the data get sorted. > > > > Instead of > > Value > > B > > C > > A > > D > > > > It's now > > > > Value > > A > > B > > C > > D > > > > Can I get the order back to BCAD? > > > > Even the best Programming Language can't prevent Programmer from >making > > mistakes, so if you want to become a Programmer, you just have to >learn > > not to make mistakes > > > > > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
