Frequency based sort in sql [duplicate]

Question

I have a problem with sorting sql tables.

I have this:

+------+------+
| col1 | col2 |
+------+------+
| a    |    1 |
| b    |   3  |
| c    |    4 |
| d    |    3 |
| e    |    2 |
| f    |    2 |
| g    |    2 |
| h    |    1 |
+------+------+

And i need to have this:

+------+------+
| col1 | col2 |
+------+------+
| e    |    2 |
| f    |    2 |
| g    |    2 |
| a    |    1 |
| h    |    1 |
| b    |    3 |
| d    |    3 |
| c    |    4 |
+------+------+

I tried with COUNT(), but it work only with GROUP OF that's why it isn't what i need.

Sorry for my bad english and thanks for all responses.

Answer 1

If database supports OVER clause then it is quite simple:

SELECT t.id, t.value
FROM t
ORDER BY count(*) over (partition by value) DESC

See SQL Fiddle - http://sqlfiddle.com/#!6/ce805/3