[ broker @ 24.01.2006. 11:29 ] @
Treba da iz tabele izvucem slicajno izabranih N slogova, ali da ih prikazem sortirano. Bice da ne moze jednim upitom ali rekoh da pitam pre nego sto odustanem. MySQL 4.1.14 |
[ broker @ 24.01.2006. 11:29 ] @
[ Damjan S. Vujnovic @ 24.01.2006. 13:26 ] @
select * from (select * from XXX order by rand() limit YYY) a order by ZZZ;
Copyright (C) 2001-2025 by www.elitesecurity.org. All rights reserved.
|