GeekArticles
FAQ
Oracle FAQ
FAQ
Oracle FAQUsing functions in queries
HI,
I am trying to wite a compound sql query which tries to compare data between 2 tables. Firstly, I need to roll up data in table1, to do this I use:
<code>
select SUM(t1.a * t2.b) DOLLARS,
SUM(t1.c) CALLS, SUM(t1.a) MINS, t1.produc...
Sponsored Links
Read Next: pivoting of rows into columns
Related Topics
Subscribe via RSS
Oracle FAQ
- Synchronize data from remote location
- Oracle Fundamentals
- How to connect SQLPlus without tnsnames.ora
- Best Practices for App Server Keep Alive
- bind variables in triggers
- how to avoid outer joins
- One 900 column table versus ten 90 column tables.
- Does select generate undo ?
- Performance Question
- Help analyze statspack report
