L33_WRX

Created the below and want to add a limit of 50 rows returned to it, tried inputing limit 0,50 in a number of places without any luck - can anyone suggest a solution?

Thanks

SELECT
acf94.MTGADDSAL,
A.Mortgage,
STAGENO,
A.APPLICTYPE,
A1.ACC_REGULATED_AUTH,
A1.ACCSEQ,
A1.ACCPRODCODE ||' ' ||acm02.proddesc,
A1.ACCAMT,
A1.ACCTERM,
A1.TERMMONTHS,
A1.CALCTYPE,
MAM03.PURPOSEDESC,
A1.ACCRETAMT,
A.APPLTVEXFEES,
A.APPLICTYPE,
APPSTATUS,
A.APPDATE,
APPGROUP
FROM acf94 limit 1,50, ACM01 A1, ACT01 A, BIT41, ACM02, MAM45 M45, MAM03
WHERE acf94.mortgage = A.mortgage
AND acf94.mtgapplseq = A.applseq
AND A.MORTGAGE = A1.MORTGAGE
AND A.applseq = a1.accseq
AND A.MORTGAGE = BIT41.MORTGAGE
AND A.APPLSEQ = BIT41.APPLSEQ
AND A.APPLICTYPE = M45.APPLICTYPE
AND A.APPPRODCODE = ACM02.PRODCODE
AND A1.PURPOSECODE = MAM03.PURPOSECODE
AND APPSTATUS <> 'I'
AND STAGENO = '30'
and acm02.PRODDESC like '%BTL%'
AND ACM02.PRODSOCSEQNO = '2'

David_Wallis

select top 50 ?

ChefDude

or ... where rownum < 50 for oracle.