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
- Lazarus Release 2.0.12
- 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
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 6 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 6 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 7 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 7 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 7 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 7 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
- BDS 2006 Architect / Catastrophic Failure
by Manz in OOT more 14 years ago - tentang validasi pada saat login ?
by jajang in Reporting more 12 years ago - Membuat program Trial untuk 1 kali jalan
by EkoIndri in Tip n Trik Pemrograman more 14 years ago - Interfacing LPT1 untuk menghidupkan seven segment
by Ijal_palu in Hal umum tentang Pascal Indonesia more 15 years ago - Display MDICHILD Di Menu
by fissas in Hal umum tentang Pascal Indonesia more 13 years ago - Tuturial dan Aplikasi Menggunakan Datasnap..
by kabie in Hal umum tentang Pascal Indonesia more 11 years ago - Paradox & Rich Edit
by clark in Paradox more 15 years ago - menghitung durasi
by skh_cay in Hal umum tentang Pascal Indonesia more 11 years ago - Selisih anggal dan Jam
by ayocool in Hal umum tentang Pascal Indonesia more 14 years ago - Adu Cepat Koneksi Internet
by deLogic in OOT more 11 years ago