how to do a sql statment on this question
Posted on 1998-12-10
say I have a table like this
I want to find the person with most records in this table.
in this case, it will return: Gal 4
How do I do in sql statment to do this. please don't use Top 1 in Access. It needs to be done in 1 query, you could have subquery but it has to be 1 query.
thank you very much
win 100 pts!!! :)