SQL_Rekapitulasi Jumlah Berkas

#Jumlah total berkas antara tgl 01/01/2003 s/d 31/01/2003#

select count(*) from expe where expedatini between "01/01/2003" and "31/01/2003";


#Jumlah berkas belum selesai antara tgl 01/01/2003 s/d 31/01/2003#

select count(*) from expe where expedatini between "01/01/2003" and "31/01/2003" and stexcod="OP";


#Jumlah berkas selesai antara tgl 01/01/2003 s/d 31/01/2003#

select count(*) from expe where expedatini between "01/01/2003" and "31/01/2003" and stexcod="CL";


#Jumlah berkas selesai antara tgl 01/02/2003 s/d 28/02/2003 per subsie 4002#

select count(*) from d301 where sesucod=4002 and d301dat between "01/02/2003" and "28/02/2003"