Sql query for data

Question

I have a table with videos and every table have a username.

Example:

username | title |

John         | My car is the best

John         | My car

John         | My car

Maria        | I like google

Maria        | I like google

Jerry        | I like cheese

How to select username with most data and ordering desc?

Example:

John  -> 3
Maria -> 2
Jerry -> 1

In the future, you should include what queries you tried. – James Kingsbery Jan 24 '14 at 20:32 — James Kingsbery, Jan 24 '14 at 20:32
Sorry, is my first post. – user3233336 Jan 25 '14 at 13:50 — user3233336, Jan 25 '14 at 13:50

Dima · Answer 1 · 2014-01-24T19:59:18.227

1

select username,count(*) coun
from theTable
group by username 
order by coun desc

edited Jan 24 '14 at 19:59

answered Jan 24 '14 at 19:48

Dima

8,586
4
28
57

1

using count as a field name can get problematic since it's a reserved word. I'd suggest using something else as some compilers will balk that this. – xQbert Jan 24 '14 at 19:58

score 0 · Accepted Answer · answered Jan 24 '14 at 19:47

0

Try this sql query:

select username, times from
(select username, count(title) as times 
  from yourtable
group by username) qry
order by qry.times desc;

answered Jan 24 '14 at 19:47

Hackerman

12,139
2
34
45

You could mark this answer as correct too... – Hackerman Jan 24 '14 at 20:44

score 0 · Answer 3 · answered Jan 24 '14 at 19:49

0

SELECT name, COUNT(1) AS c FROM table GROUP BY name ORDER BY c DESC

answered Jan 24 '14 at 19:49

marcosh

8,780
5
44
74

Sql query for data

3 Answers3