[ captPicard @ 03.08.2016. 19:23 ] @
Primjer tablice

ID TOCKA VRIJEME
-------------------------
1 1 10:00:00
1 2 10:30:00


Želim rezultat

ID VRIJEME1 VRIJEME2
1 10:00:00 10:30:00

Da li je moguće to dobit kraće od pisanja union all?
[ djoka_l @ 03.08.2016. 19:58 ] @
Code (sql):

SELECT t1.id, t1.vrijeme AS vrijeme1, t2.vrijeme AS vrijeme2
FROM tocka t1, tocka t2
WHERE t1.id = t2.id
  AND t1.tocka = t2.tocka - 1
 
[ captPicard @ 03.08.2016. 21:38 ] @
Hvala, u međuvremenu doašo do ovog rješenja:

Code (sql):
SELECT id, timediff(c1500, START) FROM (

SELECT results.id,
       MAX(CASE WHEN results.point =0 THEN results.passtime END) AS START,  
       MAX(CASE WHEN results.point =1 THEN results.passtime END) AS c1500  ,
       MAX(CASE WHEN results.point =2 THEN results.passtime END) AS c3000
FROM results WHERE results.idactive = 1  AND results.TYPE <> 'd'
GROUP BY id) AS rez;