SQL Top N grouping statistics

-- Group statistics

Select a. emp_id, B. emp_name, A. dept_no, A. bb_no, A. XH, A. IDNO, A. emp_no, A. beg_date, A. over_date, A. basesal
From hrsys. DBO. empbasesal a left join hrsys. DBO. Employee B on A. emp_id = B. emp_id
Where basesal> 4000
Order by A. emp_id, basesal

-- Top N grouping statistics
Select a. emp_id, B. emp_name, A. dept_no, A. bb_no, A. XH, A. IDNO, A. emp_no, A. beg_date, A. over_date, A. basesal
From hrsys. DBO. empbasesal a left join hrsys. DBO. Employee B on A. emp_id = B. emp_id
Where (select count (1) From hrsys. DBO. empbasesal
Where emp_id = A. emp_id and basesal> = A. basesal) <= 3
And basesal> 4000
Order by A. emp_id, basesal DESC

-- Top N grouping statistics
Select a. emp_id, B. emp_name, A. dept_no, A. bb_no, A. XH, A. IDNO, A. emp_no, A. beg_date, A. over_date, A. basesal
From hrsys. DBO. empbasesal a left join hrsys. DBO. Employee B on A. emp_id = B. emp_id
Where basesal in (select top 3 basesal from hrsys. DBO. empbasesal
Where emp_id = A. emp_id order by basesal DESC)
And basesal> 4000
Order by A. emp_id, basesal

-- Group statistics

Select a. emp_id, B. emp_name, A. dept_no, A. bb_no, A. XH, A. IDNO, A. emp_no, A. beg_date, A. over_date, A. basesal
From hrsys. DBO. empbasesal a left join hrsys. DBO. Employee B on A. emp_id = B. emp_id
Where basesal> 4000
Order by A. emp_id, basesal

-- Top N grouping statistics
Select a. emp_id, B. emp_name, A. dept_no, A. bb_no, A. XH, A. IDNO, A. emp_no, A. beg_date, A. over_date, A. basesal
From hrsys. DBO. empbasesal a left join hrsys. DBO. Employee B on A. emp_id = B. emp_id
Where (select count (1) From hrsys. DBO. empbasesal
Where emp_id = A. emp_id and basesal> = A. basesal) <= 3
And basesal> 4000
Order by A. emp_id, basesal DESC

-- Top N grouping statistics
Select a. emp_id, B. emp_name, A. dept_no, A. bb_no, A. XH, A. IDNO, A. emp_no, A. beg_date, A. over_date, A. basesal
From hrsys. DBO. empbasesal a left join hrsys. DBO. Employee B on A. emp_id = B. emp_id
Where basesal in (select top 3 basesal from hrsys. DBO. empbasesal
Where emp_id = A. emp_id order by basesal DESC)
And basesal> 4000
Order by A. emp_id, basesal