Arsip: Query

more 12 years ago
slamet_linux
rekan rekan mau tanya :
klo misalnya ada table :
//Table Master
Nomor
Tanggal
Kode1
//Table Detail
Nomor
Kode2
Harga
Jumlah
Total
//////////////////////////////////////////////////////////////+
// Nomor :
// Tanggal :
// Kode1 :
//
//------------------------------------------------------------
// NOmor | Kode2 | Harga | Jumlah | Total
//------------------------------------------------------------
//
//
//
//
//
//------------------------------------------------------------
// Total
//
///////////////////////////////////////////////////////////////
statement sql nya gimana ya ? supaya hasilnya :
|==============================+
| Nomor | Tanggal | Total |
|==============================+
| xxxx | yyyyyy | zzzzzzz |
| xxxx | yyyyyy | zzzzzzz |
|==============================+
select a.Nomor, b.Tanggal, ....
from Table1 a, table2 b
where a.Nomor = b.Nomor
order by Nomor
tararengkyu

more 12 years ago
ImanD
xixixi mo jawab apa ya, bingung ini pertanyaan dah ke jawab apa emang maksudnya gwe ga ngerti,
coba sample datanya skalian bro

more 12 years ago
Alfando
apa maksutnya mau nampilkan total nomer per tanggal?
select a.Nomor, b.Tanggal, count(a.Nomor)
from Table1 a, table2 b
where a.Nomor = b.Nomor
order by Nomor
sori kalau salah

more 12 years ago
Alfando
select a.Nomor, b.Tanggal, count(a.Nomor) Total
from Table1 a, table2 b
where a.Nomor = b.Nomor
order by Nomor

more 12 years ago
slamet_linux
@ImanD: xixixi mo jawab apa ya, bingung ini pertanyaan dah ke jawab apa emang maksudnya gwe ga ngerti, coba sample datanya skalian bro:(( itu yang .... (titik - titik) itu pa, kan itu : select a.Nomor, b.Tanggal, .... from Table1 a, table2 b where a.Nomor = b.Nomor order by Nomor itu yang titik titik kan (sum(total) from Table2 where Nomor = :Nomor) biar jadi satu gimana ?

more 12 years ago
Wong_Jowo
mm... mas slamet mbingungi banget loh,,,
select b.nomor,a.tanggal,sum(b.total)
from table1 a, table2 b
where a.nomor = b.nomor
group by b.nomor
order by b.nomor;

more 12 years ago
slamet_linux
@Wong_Jowo: mm... mas slamet mbingungi banget loh,,,ok pa, satu pertanyaan lagi, klo misalnya yang di table detail itu field total nya tidak hanya satu misal total1, total2, total3, dst.... gimana query nya ya ?select b.nomor,a.tanggal,sum(b.total) from table1 a, table2 b where a.nomor = b.nomor group by b.nomor order by b.nomor;
select b.nomor,a.tanggal,sum(b.total1, b.total2 )
from table1 a, table2 b
where a.nomor = b.nomor
group by b.nomor
order by b.nomor;
kan ga bisa ?
more 12 years ago
ImanD
select b.nomor, a.tanggal, sum(b.total1), sum(b.total2)
from table1 a, table2 b
where a.nomor = b.nomor
group by b.nomor
order by b.nomor;
coba klo gini
more 12 years ago
Wong_Jowo
bisa kan...
group nya berdasarkan b.nomor, jadi dijumlahkan yang nomornya sama
select b.nomor,a.tanggal,sum(b.total1) as total1, sum(b.total2) as total2
from table1 a, table2 b
where a.nomor = b.nomor
group by b.nomor
order by b.nomor;
more ...
reply |
Report Obsolete
Last Articles
- Project Group dalam Lazarus
- FastPlaz Database Explorer
- Release: FastPlaz Super Mom v0.12.22
- PascalClass #3: Web Development with Free Pascal
- Makna Pascal di Pascal Indonesia
- Kulgram : Instalasi Lazarus di Perangkat Berbasis ARM
- PascalClass #1: Analisa Database dan Machine Learning
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
- Mengenal OXYGENE – Pascal For .NET
- PascalTalk #5: UX: Research, Design and Engineer
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 months ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 1 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 8 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 8 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 8 years ago
Random Topic
- [Fwd] A funny yet crazy extreme test on Delphi 7 compiler
by deLogic in Enginering more 12 years ago - SetLength,memory leak
by jordan in Hal umum tentang Pascal Indonesia more 13 years ago - Get The Computer Name
by kabuki_enemy in Tip n Trik Pemrograman more 12 years ago - help code untuk pembacaan status procecor pada delphi
by dedidavidbala in Network, Files, I/O & System more 9 years ago - Borland Delphi 2005 Updated !
by xerion in Enginering more 14 years ago - Tanya DCOM Connection....
by EkoIndri in Tip n Trik Pemrograman more 14 years ago - File yang disertakan di Inno Setup
by sandy in Tip n Trik Pemrograman more 10 years ago - tanya buat nomor halaman di quick report
by Iansx in Tip n Trik Pemrograman more 13 years ago - Baca Bandwidth
by ivan in Network, Files, I/O & System more 14 years ago - ada yang pernah pake ISO buat transaksi ATM
by alvonz in Enginering more 12 years ago