count(*) column to the right of the data?

Question

Whenever i pull out data using count from my MySQL db, it always places the count column as the left most column.

e.g.

query: select count(*),name from db.db group by name order by name desc

gets:

count(*) | name
-----------------
23       | Andy
65       | Bob
12       | Chris

Is there a way to have it like this?:

name | count(*)
-----------------
Andy | 23
Bob  | 65
Chris| 12

Did you ever tried just to invert the list of selected columns? — Seki, Jun 06 '13 at 08:36

score 1 · Answer 1 · answered Jun 05 '13 at 09:51

1

You just need to invert your count and your colimn name to have a different order

select name, count(*) from db.db group by name order by name desc

The order you will give to column in SELECT queries will be the order of returned columns

answered Jun 05 '13 at 09:51

Fabio

Salil · Answer 2 · 2013-06-05T10:23:39.803

0

Simply use

select name, count(*) from db.db group by name order by name desc

edited Jun 05 '13 at 10:23

answered Jun 05 '13 at 09:50

Salil

score 0 · Accepted Answer · answered Jun 05 '13 at 09:51

0

Just switch name and count in your select

select name,count(*) from db.db group by name order by name desc

answered Jun 05 '13 at 09:51

Alexander Olsson

score 0 · Answer 4 · answered Jun 05 '13 at 09:52

0

Try this:

SELECT name, COUNT(*) FROM db.db GROUP BY name ORDER BY name DESC

answered Jun 05 '13 at 09:52

Gimmy

score 0 · Answer 5 · answered Jun 05 '13 at 09:52

0

Just change your output sequence like this :

query: select name,count(*) from db.db group by name order by name desc

answered Jun 05 '13 at 09:52

Naresh J

score 0 · Answer 6 · answered Jun 05 '13 at 09:53

0

select name,count(*) as cnt from db.db group by name order by name desc

answered Jun 05 '13 at 09:53

som

score 0 · Answer 7 · answered Jun 05 '13 at 09:58

0

Try:

SELECT NAME,COUNT(*) AS cnt FROM db.db GROUP BY NAME ORDER BY NAME DESC

answered Jun 05 '13 at 09:58

Sathish D

7 Answers7