SQL Query using count(*)

Question

I am wanting to list names and the number of times they have done a certain action. I then want to order the names by the most amount of times.

I have the below code so far but I keep getting errors:

select name, count(*) as NoOfTimes
from CustName
group by count(*);
order by count(*) asc;

You have an extra semicolon before the order by. This seems like a simple typographical error to me. — Gordon Linoff
– Gordon Linoff, Commented Dec 29, 2016 at 3:17

Vamsi Prabhala · Accepted Answer · 2016-12-29 03:19:56Z

1

I should note that if you want the most times at the beginning of the result set, the you want a descending sort:

select name, count(*) as NoOfTimes
from CustName
group by name
order by count(*) desc;

Vamsi Prabhala

49.4k4 gold badges41 silver badges64 bronze badges

answered Dec 29, 2016 at 3:18

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

phnkha · Accepted Answer · 2016-12-29 03:18:44Z

1

In order to show count by name, you must group by name

select name, count(*) as NoOfTimes
from CustName
group by name
order by NoOfTimes desc

answered Dec 29, 2016 at 3:18

phnkha

7,9102 gold badges26 silver badges31 bronze badges

Shushil Bohara · Accepted Answer · 2016-12-29 03:23:49Z

0

Order by index also a good idea:

select name, count(*) as NoOfTimes
from CustName
group by name
order by 2 DESC

answered Dec 29, 2016 at 3:23

Shushil Bohara

5,6662 gold badges19 silver badges32 bronze badges