asp.net - iam need this query from db -

asp.net - iam need this query from db -

please help me excute query

id fdevicename fdevicetype 1 case mini 2 rack b 3 amir d 4 rack 5 case max 6 case mini

i want query back

id fdevicename fdevicetype count 1 case mini 2 2 rack b 1 3 amir d 1 4 rack 1 5 case max 1

select id, fdevicename, fdevicetype, count(*) table grouping fdevicename, fdevicetype

asp.net sql-server