Dear Hutsu, Errornya seperti apa yaa..?. Tujuannya untuk apa melakukan order didalam table tersebut dan setelah itu di count. Kenapa tidak langsung saja : SELECT count(*) FROM table1.
Thanks IH *yangnyobabelajarmenjawab --- On Wed, 10/8/08, hutsu.sendul <[EMAIL PROTECTED]> wrote: From: hutsu.sendul <[EMAIL PROTECTED]> Subject: [indo-oracle] ERR sql To: [email protected] Date: Wednesday, October 8, 2008, 1:04 AM 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 [Non-text portions of this message have been removed]
