Search SSWUG.ORG:

DATABASES

How To Not Include a Column From The SELECT List In The GROUP BY Clause




Sometimes you do not need to group by each column or expression included in the SELECT list of the query. For example, you may want to not include ROWNUM in the GROUP BY clause in spite of the fact that it appears in the SELECT list. This article explains how you might do that with the help of an inline view.

Read this article...







comments powered by Disqus