wudu Posted January 7, 2006 Report Posted January 7, 2006 tabulaa kolonas saturs: ieraxts1 ieraxts1 ieraxts2 ieraxts2 ieraxts2 ieraxts3 vajag dabuut visus unikaalos ieraxtus un sakaartot peec to atkaartoshanaas biezhuma. rezultaats: ieraxts2 ieraxts1 ieraxts3 zinu, ka shis jau neskaitaamas reizes apspriests, bet nekur nevaru atrast...
Aleksandrs Posted January 7, 2006 Report Posted January 7, 2006 SELECT COUNT(kolonna) as cik FROM news GROUP BY kolonna ORDER BY cik DESC Šādi?
bubu Posted January 7, 2006 Report Posted January 7, 2006 (edited) Man liekas ka šitā gan: SELECT kolonna FROM tabule GROUP BY kolonna ORDER BY COUNT(kolonna) DESC Edited January 7, 2006 by bubu
Recommended Posts