[Gabriel Khoa Bui]

The config of my table as below:

| Id | Device|
————————————
| SR200604001 | Server
| SR200604002 | Server
| RO200604001 | Router
| RO00604002 | Router
| PJ200604001 | Projector

Using ‘COUNT’ operator, how to get total of rows that is ordered by every device? I take an example,
Server | 2
Router | 2
Projector | 1

Thanx!

[Riyad Kalla]

Moving to OT > Soft Dev

[Brian Fernandes]

select device, count(id) from tableName group by Device;

I’m not 100% sure that would work, but give it a shot.

Brian.

[Gabriel Khoa Bui]

It works! Thank you very much!

[Author]

Posts