SELECT DECODE(RN,1,TABLE_NAME),TABLE_NAME,COLUMN_NAME,COMMENTS FROM ( SELECT USER_COL_COMMENTS.* , ROW_NUMBER() OVER(PARTITION BY TABLE_NAME ORDER BY ROWNUM ) rn FROM USER_COL_COMMENTS WHERE TABLE_NAME LIKE 'TABLE_%'; )