如何查询下面的结果表。 [英] How to query for retriving below result table.

问题描述

我有这样的桌子吗？

i have table like this?

id	name	address	age	salary	product	reports to
1	kiran	medak	54	8600	JK	ajay
2	naresh	karimnagar	42	25000	JK	ajay
3	Prasad	khammam	25	5600	KL	mari
4	Prasad	khammam	25	6600	JK	ajay
5	rajesh	rangareddy	45	8600	MK	prakash
6	ramesh	Ahmedabad	32	2000	JK	ajay
7	ramesh	Ahmedabad	32	3000	KL	mari
8	ramesh	Ahmedabad	32	4000	MK	prakash
9	sreenu	hyderabad	22	2600	JK	ajay
10	vijay	kg,	36	20600	KL	mari

i需要这样的结果怎么做查询？

i need result like this how to do query?

id	name	address	age	salary	product	reports to
1	kiran	medak	54	8600	JK	ajay
2	naresh	karimnagar	42	25000	JK	ajay
4	Prasad	khammam	25	6600	JK	ajay
5	rajesh	rangareddy	45	8600	MK	prakash
8	ramesh	Ahmedabad	32	4000	MK	prakash
9	sreenu	hyderabad	22	2600	JK	ajay
10	vijay	kg,	36	20600	KL	mari

i尝试自我加入



每人最高工资记录？

i tried self join

highest salary record per each person ?

推荐答案

使用 ROW_NUMBER（）排名函数 [ ^ ]获得最高薪水。

Use ROW_NUMBER() ranking function[^] to get the highest salary.

SELECT *
FROM (
    SELECT PersonName, Salary, ROW_NUMBER() OVER(PARTITION BY PersonName ORDER BY Salary DESC) As RowNo
    FROM TableName
)
WHERE RowNo = 1

下次请使用 SearchBox with statement：最高薪水 [ ^ ]。

这篇关于如何查询下面的结果表。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！