i am new to sql. I trying to limit the result of a query to 3 output per group from the table.
For example, I want to find the top 3 highest salary in each state. So i would like to group by state and limit the result to the top 3 of each group.

Expecting a query that return top 3 result from each group.