Lets say I have a table A ,

```
A

    user count
    a      4
    b      1
    c      3
    d      2 

```

I want to write a query which returns each value of A along with max value of count,something like 

```
user  maxCount
a        4
b        4
c        4
d        4 

```

The way I am trying to achieve this is, 

```
select user,max(count) as maxCount from A

```

The result which I get is :

```
user maxCount
a      4

```

Which is clearly not what I want.

I understand I could write multiple queries(i.e. 'select user from A' /'select max(count) from A') as this may seem redundant ,

but I think having it this way would be best for me as I don't want to call mysql multiple times and also I push the returned data as a single jsonObj to the front end , so it is easier to have a single table then combing two returned-tables into one and than converting into json