MySQL Forums
Forum List  »  MySQL Query Browser

Re: SELECTING AVG FROM A TABLE QUESTION
Posted by: irek kordirko
Date: February 11, 2012 04:39PM

try this:
SELECT * FROM emp
WHERE empsalary > (
         SELECT avg( empsalary )
         FROM emp
 )

Options: ReplyQuote


Subject
Written By
Posted
C R
February 11, 2012 10:12AM
Re: SELECTING AVG FROM A TABLE QUESTION
February 11, 2012 04:39PM


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.