Sabtu, 16 Juli 2011
Query Iseng
select * from (
select a.kodebarang, namabarang, max(tanggal) tanggal
from harga a
inner join barang b on (a.kodebarang=b.kodebarang)
group by a.kodebarang, namabarang
) x
inner join harga y on (x.kodebarang=y.kodebarang and x.tanggal=y.tanggal)
order by x.kodebarang
Langganan:
Posting Komentar (Atom)
0 comments:
Posting Komentar