dear all, apakah mungkin query ini bisa lebih di sederhanain lagi agar efisien dan lebih cepat , atau ada alternatif lain ?
select trx_number,trx_date from customer_trx
where trx_number in(
select trx_number from customer_trx
where trx_date > '01-JUN-07'
group by trx_number having count(*) > 1)
regards
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
