How To Not Include a Column From The SELECT List In The GROUP BY Clause Sometimes you don’t 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....