I have a column (assett_name) that contains names of workstations that have been logged as faulty. I want to be able to work out how many entries a particular workstation has in that table.
If I was to select the above list - I would like it to bring back the following:
Hope you can help
this is a plain COUNT() with a GROUP BY:
SELECT asset_name ,
COUNT(*) AS total
GROUP BY asset_name ;
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?