First n rows

Hi!

I have two tables:

Table1:
id varchar2(10),
partner varchar2(30)

Table2:
id varchar2(10),
value1 number(15,2),
value2 number(15,2),
...

I wrote query like this:

SELECT DECODE(SIGN(s.sum), -1, 'P', 'D') AS dp,

s.sum_dug, s.sum_dug_30, s.sum_dug_60, s.sum_dug_90,

s.sum_dug - (s.sum_dug_30 + s.sum_dug_60 + s.sum_dug_90) AS sum_dug_preko_90,

s.sum_dug_dos,

p.pp_sif, p.ppnaz1, p.ppnaz2, p.ppnaz3, p.ppnaz4

FROM md_ppt p,

(SELECT konto_anl,

SUM(NVL(stanje_d, 0) - NVL(stanje_p, 0)) AS sum_dug,

SUM(DECODE(SIGN(SYSDATE - d_valute), -1, 0, NVL(stanje_d, 0) - NVL(stanje_p, 0))) AS sum_dug_dos,

SUM(DECODE(TRUNC((SYSDATE - d_izd_dok) / 30), 0, NVL(stanje_d, 0) - NVL(stanje_p, 0), 0)) AS sum_dug_30,

SUM(DECODE(TRUNC((SYSDATE - d_izd_dok) / 30), 1, NVL(stanje_d, 0) - NVL(stanje_p, 0), 0)) AS sum_dug_60,

SUM(DECODE(TRUNC((SYSDATE - d_izd_dok) / 30), 2, NVL(stanje_d, 0) - NVL(stanje_p, 0), 0)) AS sum_dug_90

FROM sk_anal

WHERE konto LIKE :konto

AND konto_anl LIKE :konto_anl

AND NVL(td_sif, 'X') LIKE :td_sif

AND NVL(kto_anl1, 'X') LIKE :org_sif

AND NVL(stanje_d, 0) - NVL(stanje_p, 0) <> 0

GROUP BY konto_anl) s

WHERE p.pp_sif = s.konto_anl

ORDER BY dug_pot, ABS(s.sum_dug) DESC, p.ppnaz1, p.pp_sif

I need to write query

--
Ivica Dimjasevic
remove_smokesoft_at_email.hinet.hr
http://come.to/smokesoft/