create table with top 5 items
I have a dilemma. In my database I have a source table which is filled by a custom value list from an SQL-database.
The sourcetable consists of date, line,workplace,code,min-downtime and has records of the past 6 days. Now I want in a seperate table a list of the top5 codes based total min-downtime.
unfortunately I am a bit stuck at this. Anyone any tips how to create this top5 list?