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博客 ” ，链接：https://blog.itpub.net/25556429/viewspace-1054842/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
SQL养成一个好习惯是一笔财富
请登录后发表评论
登录
全部评论
