AnsweredAssumed Answered

create table with top 5 items

Question asked by d.vanlooij on Apr 8, 2014
Latest reply on Apr 10, 2014 by d.vanlooij

Title

create table with top 5 items

Post


     Hi,

     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?

Outcomes