Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL query: how can I hide a column in output?

Re: SQL query: how can I hide a column in output?

From: Ray Saltrelli <reymundo514_at_gmail.com>
Date: 17 Aug 2006 11:52:28 -0700
Message-ID: <1155840748.342646.326010@i3g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US