I've got columns like:
counter | name | date | data
I would like to sort like this
SELECT * FROM monitor order by counter DESC LIMIT $howmuch;
That gives me last ten($howmuch) records by counter but i want later order again but by name;
I've tried something like
order by counter,name
or
order by name,counter
But none of above gave me what i wanted Basically I want 10 last records sorted by name.