Return null as 0 in oracle select statement
select nvl (sum(com.AMOUNT),0) from EPF e inner join bib_company_transaction com on e.parent_oid = com.trnx_id where status='T' and com.UPDATED_DATE between to_date('20111018', 'yyyymmdd') and to_date('20111019', 'yyyymmdd')
Subscribe to:
Post Comments (Atom)
finland says it can teach tourists to be happy cha...
cik pon bakal talak satu
nahas karak pemandu lori direman empat hari
berbuka 29 puasa soto lembu angah
anda saksikan sendiri sikap peniaga di jalan tar
mykad madani memudahkan bantuan kerajaan menyejaht...
hati hati dengan scam pengeluaran kwsp akaun 1 tak...
environmental group criticises s gor for skipping ...
persiapan aidilfitri sebuah keluarga peneroka di f...
no lessons learnt hindu temple row leaves only a b...
tak layan mengarut
Resepi Telur Bungkus Paling Menepati Selera Puas Hati Bila Isinya Lebih
No comments:
Post a Comment