[Resolved] Query Count List

[nomad9]

Hi all,

i need to create a list from a query that'll count the number of row associate with a type (from 1 to 3) and display the number of row of each type in DESC order

For example:

row1 = type1
row2 = type3
row3 = type2
row4 = type1
row5 = type2
row6 = type2

so the list need to display the query like this :

type2 = 3
type1 = 2
type3 = 1

can someone have an idea how i can do that ???

nomad

[tserbis]

SELECT type, COUNT(*) AS c
FROM tbl
GROUP BY type
ORDER BY c DESC

[nomad9]

what's the c in your query ??

[tserbis]

Manual:
You can use an alias to refer to a column in the GROUP BY, ORDER BY, or in the HAVING part. Aliases can also be used to give columns better names:

SELECT SQRT(ab) as rt FROM table_name GROUP BY rt HAVING rt > 0;
SELECT id,COUNT() AS cnt FROM table_name GROUP BY id HAVING cnt > 0;
SELECT id AS "Customer identity" FROM table_name;