...

Arsip: Cara Null + Numeric dg query?

 
user image
more 19 years ago

ZeAL

nanya yaaaa... dengan query, gimana sih cara menjumlahkan 2 field atau lebih yang tipe datanya sama2 numeric tapi ada yang isinya null..?? Tapi jangan merubah default valuenya jadi 0.. tengkyuuu...
user image
more 19 years ago

kaka-delphi

Coba skrip kaya gini bisa ga yach ? 
SELECT SUM(FieldNum) FROM TabelAnu WHERE FieldNum IS NOT NULL
user image
more 19 years ago

cyber_hecker

wakakaka :D.. ternyata ada yang menghadapi masalah kayak gue dulu yach :P. gue gak tau kalo menggunakan database lain. klo menggunakan ms SQL server gue menggunakan perintah : 
SELECT Nilai1, Nilai2, 
  ISNULL(Nilai1, 0) + ISNULL(Nilai2, 0) AS Jumlah
FROM
  Table1
user image
more 19 years ago

ZeAL

ok..ok..tengkyu..
more ...
  • Pages:
  • 1
|
Share to

AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now: https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD

Last Articles

Last Topic

Random Topic

Local Business Directory, Search Engine Submission & SEO Tools FreeWebSubmission.com SonicRun.com