kirain table..! klo file.txt kurang paham gmn bacanya klo di oracle.. monggo agan2 yg lain..
On Tue, Jun 8, 2010 at 4:50 PM, romy <[email protected]> wrote: > > > Gan klo pk awk bs gak ? > > tabelnya itu dalam bentuk file txt. > > > wendi gunawan wrote: > > > > > > oww sori gw revisi lagi.. > > > > select > > number as numbers, > > total_onnet as onnet, > > total_offnet as offnet, > > total_international as international, > > total_onnet+total_offnet+total_international as TOTAL > > > > from( > > select > > number, > > sum((case when jenis=1 then total else 0 end))total_onnet, > > sum((case when jenis=2 then total else 0 end)) total_offnet, > > sum((case when jenis=3 then total else 0 end)) total_international > > > > from( > > select number,total, 1 as jenis from t_onnet > > union all > > select number,total, 2 as jenis from t_offnet > > union all > > select number,total, 3 as jenis from t_international > > ) x > > group by number > > ) y > > > > On Tue, Jun 8, 2010 at 1:19 PM, wendi gunawan > > <[email protected]<wendi.gunawan%40gmail.com> > > <mailto:wendi.gunawan%40gmail.com <wendi.gunawan%2540gmail.com>>>wrote: > > > > > > select > > > number as numbers, > > > total_onnet as onnet, > > > total_offnet as offnet, > > > total_international as international, > > > total_onnet+total_offnet+total_international as TOTAL > > > > > > from( > > > select > > > number, > > > sum((case when jenis=1 then total else 0 end))total_onnet, > > > sum((case when jenis=2 then total else 0 end)) total_offnet, > > > sum((case when jenis=3 then total else 0 end)) total_international > > > > > > from( > > > > > > select number,count(*) total, 1 as jenis from t_onnet > > > group by number > > > union all > > > select number,count(*) total, 2 as jenis t_offnet > > > group by number > > > union all > > > select number,count(*) total, 3 as jenis t_international > > > group by number > > > ) x > > > group by number > > > ) y > > > > > > > > > > > -- wendi gunawan Java Software Developer & penulis (new bie) terus belajar untuk tidak cinta dunia http://oretanwendi.wordpress.com/ hp:085624046906 [Non-text portions of this message have been removed]
