Re: want to use the result of an sql query in another query
Posted by: Todd Farmer
Date: October 17, 2012 02:09PM

Hi sarra,

It sounds like you could use something like:

SELECT * FROM table
WHERE (Credit, Cell_id) IN
(SELECT MAX(Credit), Cell_id FROM table GROUP BY Cell_id) tmp;

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/

Options: ReplyQuote


Subject
Written By
Posted
Re: want to use the result of an sql query in another query
October 17, 2012 02:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.