Cari Min N Max

[pelangi pixel 0]

Saya nk tanye camne nk cari min n max value dari recordset yang ade dalam page
Sql utk recordset saye:

contoh :

table: evaluation
lect id | eva_a1 | eva_a2 | eva_a3
1 2 2 2
1 3 3 3
2 1 1 1
3 2 4 4
3 1 3 3

then pas sql

Recordset(Recordset8)

SELECT lect_id,sum(eva_a1+eva_a2+eva_a3)
FROM evaluation
GROUP BY lect_id

output:
lect id | sum
1 15
2 3
3 17

so.. cmne nk cari lect_id mane yang ade sum paling max n paling min..

saye try create view utk wat virtual table gune sqlyog tapi tak leh...

thank u

ps: confused nk post kt sql ke kt php