Home Forums SQL Server 2005 T-SQL (SS2K5) Select second row of a table RE: Select second row of a table

  • September 7, 2014 at 10:56 am

    #1743719

    baijuep (9/7/2014)

    Sir, i tried the second query and it gives following error

    Msg 8120, Level 16, State 1, Line 1

    Column 'Trade.Trade' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

    I'm sure that if you know the basics of SQL, you should be able to add the missing GROUP BY clause that I missed. 😉

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2