å
·ä½çä½ ä»ä¹æ°æ®åºäºï¼è¿æä½ å段1ï¼å段2ï¼å段3åªä¸ªå段æ¯å符类åçã
æ¯å¦å段3æ¯å符类åï¼
oracleåæ³ï¼
SELECT å段1,å段2,å段3 FROM æå°æ°æ®è¡¨ where æå°æ¶é´>='2018-09-01' AND æå°æ¶é´<'2018-09-19'
union all
select null,null,'å计ï¼'||count(*) from æå°æ°æ®è¡¨ where æå°æ¶é´>='2018-09-01' AND æå°æ¶é´<'2018-09-19'
mysqlåæ³ï¼
SELECT å段1,å段2,å段3 FROM æå°æ°æ®è¡¨ where æå°æ¶é´>='2018-09-01' AND æå°æ¶é´<'2018-09-19'
union all
select null,null,concat('å计ï¼',(cast(count(*) as varchar) from æå°æ°æ®è¡¨ where æå°æ¶é´>='2018-09-01' AND æå°æ¶é´<'2018-09-19'
sqlserveråæ³ï¼
SELECT å段1,å段2,å段3 FROM æå°æ°æ®è¡¨ where æå°æ¶é´>='2018-09-01' AND æå°æ¶é´<'2018-09-19'
union all
select null,null,'å计ï¼'+(cast(count(*) as varchar) from æå°æ°æ®è¡¨ where æå°æ¶é´>='2018-09-01' AND æå°æ¶é´<'2018-09-19'
追é®ä¸ågan xie
æè°¢