GeekArticles
FAQ
Oracle FAQ
FAQ
Oracle FAQTop-N query over several years avoiding union
Hello Tom,
First of all: HAPPY NEW YEAR and many thanks for all your help in 2006.
I struggle with the following top-500 query, over multiple years:
<code>
SELECT to_char(year, 'rrrr') YEAR
, (SELECT resp_nr FROM pan_Respondents WHERE...
Sponsored Links
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
