28 January 2012

sort by occurence of anyvalue in a column

SELECT * , COUNT( ref ) AS occurances FROM table GROUP BY ref ORDER BY occurances DESC
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)