Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL query: how can I hide a column in output?
Sometimes you may need to have a column in the SELECT clause in order
to group by that column, for example, but you may not want to actually
display it. Try this:
SELECT a, b, FROM (SELECT a, b, c FROM Table1 GROUP BY c ); Received on Thu Aug 17 2006 - 13:52:28 CDT
![]() |
![]() |