how to select most Name frequent from table in SQL-Server

Question

i have table have a lot of Names like this

    MrMiroBear

    MrMiroBear

    BigBear

    MrMiroBear

    BigBear

    MrMiroBear

    MrMiroBear

    BigBear

    MrMiroBear

    MrMiroBear

    BigBear

    MrMiroBear

    BigBear

    BigBear

    MrMiroBear

    BigBear

    BigBear

    MrMiroBear

    BigBear

i want select most Name frequent in this table how i can do this?
and i want give me the name only like (BigBear) not number of count

and i try this Query but it's give me only count of name not name

select Top 1 Count(*) as TopName From _Client group by ClientName

Answer 1

If your query works, you are not using MySQL.

The answer to your question would then be:

select Top 1 ClientName
From _Client
group by ClientName
order by count(*) desc;

In other words, you have to select the field that you want.

Note: There could be ties. If you want all top client names:

select Top (1) With Ties ClientName
From _Client
group by ClientName
order by count(*) desc;

how to select most Name frequent from table in SQL-Server

Sign up