select DETECTMODE,sum(TotalTime) from
(select DetectMode, round(to_number(EndTM - StartTM)*1440) as TotalTime from TableA)group by DETECTMODE
得到的结果是
1 111
2 222
3 333
4 444select DETECTMODE,count(*) from tb_tc_areatrace group by DETECTMODE 得到的结果是
1 AAA
2 BBB
3 CCC
4 DDD怎么把它俩连起来得到
1 111 AAA
2 222 BBB
3 333 CCC
4 444 DDD
(select DetectMode, round(to_number(EndTM - StartTM)*1440) as TotalTime from TableA)group by DETECTMODE
得到的结果是
1 111
2 222
3 333
4 444select DETECTMODE,count(*) from tb_tc_areatrace group by DETECTMODE 得到的结果是
1 AAA
2 BBB
3 CCC
4 DDD怎么把它俩连起来得到
1 111 AAA
2 222 BBB
3 333 CCC
4 444 DDD
from (select DetectMode, round(to_number(EndTM - StartTM)*1440) as TotalTime from TableA)A,
(select DETECTMODE,count(*) XXX from tb_tc_areatrace group by DETECTMODE )B
where A.DETECTMODE=B.DETECTMODE
不过下面的语句会得到这个结果吗?
select DETECTMODE,count(*) from tb_tc_areatrace group by DETECTMODE 得到的结果是
1 AAA
2 BBB
3 CCC
4 DDD
(select DetectMode, round(to_number(EndTM - StartTM)*1440) as TotalTime from TableA)group by DETECTMODE
得到的结果是
1 111
2 222
3 333
4 444 select DETECTMODE,count(*) from TableA group by DETECTMODE 得到的结果是
1 AAA
2 BBB
3 CCC
4 DDD 得到
1 111 AAA
2 222 BBB
3 333 CCC
4 444 DDD
FROM
(
select DETECTMODE,sum(TotalTime) from
(select DetectMode, round(to_number(EndTM - StartTM)*1440) as TotalTime from TableA)group by DETECTMODE )A,
(select DETECTMODE,count(*) XXX from TableA group by DETECTMODE )B
WHERE A.DETECTMODE=B.DETECTMODE