Home Forums SQL Server 2008 SQL Server Newbies need summarized info in the sql join queries RE: need summarized info in the sql join queries

  • June 18, 2015 at 12:41 am

    #1806263

    hey!

    use this code you will get the desired output.

    SELECT distinct SPEED, AVG(PRICE) as AVG_PRICE FROM PC GROUP BY SPEED

    HAVING SPEED>600