Tech Tutorials Database
GeekArticles FAQ Oracle FAQ
 

Top-N query over several years avoiding union

 
Author: asktom.oracle.com
Category: Oracle FAQ
Comments (0)

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...

Read More...




Sponsored Links




Read Next: Shared Server response queue and log switch relationship with checkpoint



 

 

Comments



Post Your Comment:

Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe