select do tabulky

zdeniatqo · Napísal **zdeniatqo**: 26.06.2011 13:32

Ahojte

,

potrebovala by som mensiu radu....
ako sa da select ulozit ako tabulka? konkretne sa jedna o select

SELECT caller,
called,
sum(duration),
sum(duration_unit_count),
sum(free_unit_count),
sum(paid_unit_count)
FROM data
GROUP BY caller;

vopred vdaka

emer · Napísal **emer**: 26.06.2011 14:16

Kód:

CREATE TABLE nova_tab (caller char(10), called char(10), sum_duration int(10) ... ); #doplnis ostatne stlpce

INSERT INTO nova_tab SELECT caller, 
 called, 
 sum(duration), 
 sum(duration_unit_count), 
 sum(free_unit_count), 
 sum(paid_unit_count) 
FROM data 
GROUP BY caller;

zdeniatqo · Napísal autor témy **zdeniatqo**: 26.06.2011 14:44

vdaka

select do tabulky

Podobné témy