P'Hutsu, Pada dasarnya syntax dasar SQL hampir sama antara SQLServer dng ORACLE, paling ada beda2 dikit di featurenya. U/ masalah dibawah, sebenernya apa tujuan P'Hutsu, kalo hanya skedar htg jumlah record syntaxnya cukup (syntax ini bs jalan di ORACLE maupun SQL Server) select count(*) from table1 meskipun dng syntax P'Hutsu juga bisa cuma tidak efisien. select count(*) from (select * from table1 order by fnid) x
Saya yakin permasalahan ada pada clause order by fnid(ada g kolom ini), atau table1(ada g tablenya) ----- Original Message ---- From: hutsu.sendul <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, October 8, 2008 5:04:03 AM Subject: [indo-oracle] ERR sql 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]
