SQL Server Performance

MAX(AVG(SAL))

Discussion in 'SQL Server 2008 General DBA Questions' started by RVG, Jan 15, 2010.

  1. RVG Member

    Hi,
    When I tried to execute the below given query it is getting executed in Oracle but it is not getting executed in SQL or MYSQL. Can any one help me in solving this query.
    Table is the basic(predefined schema) employee table in Oracle.
    Query:
    select max(avg(sal)) from employee group by deptno; //executes in Oracle//
    but when I write the same above query using max(avg(sal)) this function gives an error in MYSQL
    Thanks and Regards,
    Ravi Varma G
    RVG, Jan 15, 2010
    #2

  2. preethi Member

    Please do not make duplicate posts. It will multiple posts running in parallel. This issues is discussed in a different thread: http://sql-server-performance.com/Community/forums/t/31392.aspx
    Moderators, Can we close this thread please :)
    preethi, Jan 15, 2010
    #3

  3. Luis Martin Moderator

    I've locked.
    Luis Martin, Jan 16, 2010
    #4

Share This Page