උත්තරේ හරිද බලන්න
SELECT M.Kudu, M.Polis, M.Ekaka, M.Wasara FROM (
SELECT Kudu, MAX(Ekaka) Ekaka
FROM (
SELECT Kudu, SUM(Ekaka) Ekaka
FROM SriLankaPolis
WHERE Wasara=2017
GROUP BY Kudu, Polis, Wasara
) D
GROUP BY Kudu) P
INNER JOIN
( SELECT Polis, Kudu, SUM(Ekaka)...