Jump to content

Archived

This topic is now archived and is closed to further replies.

MeanMrMustard

Top Ten style search

Recommended Posts

I have a DB where the results of a incentive program are kept.

Each employee who receives a merit goes into this DB. Can someone help me write a query that produces a ranking from the DB. Every Merit produces another entry in the DB so I can count the number of instances f any one employee while in a loop but can seem to create a ranking style output.

Any help would be appreciated.

Share this post


Link to post
Share on other sites
I'm guessing you have a structure similar to this


[code]employee             merit
---------            ----------
emp_id    ----+      id
emp_name      |      award_date
              +---<  emp_id
[/code]


[code]$sql = "SELECT e.emp_name, COUNT(*) AS merits
        FROM employee e INNER JOIN merit m
        ON e.emp_id = m.emp_id
        GROUP BY e.emp_name
        ORDER BY merits DESC";[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.