One of the features I absoluetly love about Oracle is the over() function.. If you have a recordset and are trying to get multiple sums of columns grouped by different columns.. in MSSQL you'd have to create multiple queries right? select sum(a, b) from foo group by c
select sum(a, c) from foo group by b etc... unless MSSQL has an answer for this.. In Oracle I do select sum(a, b) over (partition by c) as sumab, sum(a, c) over (partition by b) as sumac from foo You can see the benefits here,,, As far as TOP, Oracle has rownum select * from foo where rownum <= 5 On Sat, May 3, 2008 at 5:40 PM, Cameron Childress <[EMAIL PROTECTED]> wrote: > They are essentially the same for more of your everyday queries. There are > a couple of minor differences (like the TOP keyword), but mostly they are > the same syntax-wise. When you get into more advanced stuff (like triggers) > they do differ. > > Also worth noting - CF Standard supports MS SQL out of the box. For Oracle > drivers you have to either pay for CF Enterprise or download and install > your own JDBC drivers. > > -Cameron > > On Fri, May 2, 2008 at 10:19 PM, C. Hatton Humphrey <[EMAIL PROTECTED]> > wrote: > > > What is the difference between CF + MSSQL and CF + Oracle? > > > > Is the query structure for Oracle that much different? > > > > > > -- > Cameron Childress > Sumo Consulting Inc > http://www.sumoc.com > ---cell: 678.637.5072 > aim: cameroncf > email: [EMAIL PROTECTED] > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:259734 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
