wudu Posted January 7, 2006 Report Share 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... Link to comment Share on other sites More sharing options...
Aleksandrs Posted January 7, 2006 Report Share Posted January 7, 2006 SELECT COUNT(kolonna) as cik FROM news GROUP BY kolonna ORDER BY cik DESC Šādi? Link to comment Share on other sites More sharing options...
bubu Posted January 7, 2006 Report Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts