Citat:
|
Originalno napisao zextra
Kôd:
...
FROM
`t1` s1,
`t1` s2,
( SELECT id, min(value) AS 'min' FROM `t1` GROUP BY id ORDER BY id ) q1,
( SELECT id, max(value) AS 'max' FROM `t1` GROUP BY id ORDER BY id ) q2
WHERE
...
|
Ovo moram da probam. Nikad mi ne bi palo na pamet da ovde uglavim SELECT. Ja sam probavao da slicno uradim u LEFT JOIN ali nije proslo posto funkcije ne rade u LEFT JOIN uslovu.