Hello all,
I am attempting to run a query that shows the three highest values by group. This is for an audit program that has four layers (ecoat, primer, e1 and e2). I want the top three values for each of these to be displayed. I can do the top three (select top 3), but this doesn't do the top 3 for each group. Any ideas?
I am attempting to run a query that shows the three highest values by group. This is for an audit program that has four layers (ecoat, primer, e1 and e2). I want the top three values for each of these to be displayed. I can do the top three (select top 3), but this doesn't do the top 3 for each group. Any ideas?