how to use top 1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • poopsy
    New Member
    • Nov 2006
    • 50

    how to use top 1

    i want to retireve the first row for the following query
    Code:
    select TOP 1 t.vid,max(c) from (select vid,count(*) as c from buys group by vid) t group by t.vid;
    bt i get a syntax error near 1...
    did i do it wrong
    plzzz help
  • ganeshkumar08
    New Member
    • Jan 2008
    • 31

    #2
    select max(cnt) from
    (
    select count(*) as cnt
    from dbo.TrendCLUBS
    group by Club_HomeColor

    ) a

    Comment

    Working...