select vin_id,substr(aa,0,19),substr(aa,21,19),substr(aa,41,19)
from (
select t.vin_id,WMSYS.WM_CONCAT(to_char(t.starttime,'yyyy/mm/dd hh24:mi:ss')) aa from
test_call_0906 t
group by t.vin_id)[@more@]select vin_id,substr(aa,0,19),substr(aa,21,19),substr(aa,41,19)
from (
select t.vin_id,WMSYS.WM_CONCAT(to_char(t.starttime,'yyyy/mm/dd hh24:mi:ss')) aa from
test_call_0906 t
group by t.vin_id)
from (
select t.vin_id,WMSYS.WM_CONCAT(to_char(t.starttime,'yyyy/mm/dd hh24:mi:ss')) aa from
test_call_0906 t
group by t.vin_id)[@more@]select vin_id,substr(aa,0,19),substr(aa,21,19),substr(aa,41,19)
from (
select t.vin_id,WMSYS.WM_CONCAT(to_char(t.starttime,'yyyy/mm/dd hh24:mi:ss')) aa from
test_call_0906 t
group by t.vin_id)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25556429/viewspace-1054842/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25556429/viewspace-1054842/