Grouped fastest result list usefully

1 files changed, 9 insertions, 2 deletions

diff --git a/fastest.sql b/fastest.sql
index ddda640..ce333be 100644
--- a/fastest.sql
+++ b/fastest.sql
@@ -1,5 +1,12 @@
 SELECT
   set,script,scale,clients,workers,
-  round(tps) as tps
-FROM tests
+  round(tps) AS tps
+FROM
+(
+  SELECT
+    set,script,scale,clients,workers,
+    max(tps) AS tps
+  FROM tests
+  GROUP BY set,script,scale,clients,workers
+) AS grouped
 ORDER BY tps DESC LIMIT 20;