none
Working out top 10 entries in a column

    Question

  • Hi There,

    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.

    For example:

    assett_name
    ---------------
    pc01
    pc02
    pc02
    pc03
    pc02
    pc01

    If I was to select the above list - I would like it to bring back the following:

    assett_name        total
    --------------        --------
    pc01                    2
    pc02                    3
    pc03                    1

    Hope you can help

    Thanks
    Matt

    Thursday, February 10, 2011 10:14 AM

Answers