Rank for most occuring values SQL
I have an SQL column with values in a column and I would like to know
which values occur the most in a ranked format. For example if I had data
in a table called List and a column had values as seen below:
COLUMN
one
five
five
five
three
two
eight
nine
two
one
two
two
The sql should return the top 3 values which are Two, Five and One. How
can this be done in SQL
No comments:
Post a Comment