gw newbe oracle nih, mo nanyak :

select count(*)  from (select  * from  table1 order by fnid) x

query diatas err karna ada order by fnid

kalo di SQLServer biar ngak err harus ditambain TOP 100 PERCENT,
hingga menjadi gini :

select count(*)  from (select TOP 100 PERCENT  * from  table1 order by
fnid) x

kalo di oracle gmn y??
thx

Kirim email ke