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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 9 Query Question.....Please help....

Re: Oracle 9 Query Question.....Please help....

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 16 Apr 2006 10:13:08 -0700
Message-ID: <1145207588.416577.140010@t31g2000cwb.googlegroups.com> 





Try making your query a subquery.   You can then select the
max(total_sales) where total_sales = unit*price



select prodnum, max(total_sales) from ( your_query)



HTH -- Mark D Powell --
Received on Sun Apr 16 2006 - 12:13:08 CDT












Original text of this message













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