Advertisement
Guest User

Untitled

a guest
Jul 31st, 2015
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. select o.nama, o.tgl_lhr, o.agama_id from orang o inner join pns p
  2. on p.id = o.id
  3. inner join satuan_kerja sk on sk.id = p.satuan_kerja_kerja_id
  4. where p.instansi_kerja_id = 'A5EB03E23B00F6A0E040640A040252AD'
  5. and extract(year from p.tmt_cpns) = '2014'
  6. and o.jenis_kelamin = 'F' and sk.kanreg_id = '00'
  7. order by o.nama, o.tgl_lhr;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement