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