如何在两列中选择最大值。 [英] how to select max values in two column.

问题描述

如何选择下表中的最大值

How to select maximum values in below table

day	count
0	18
4	66
5	6
6	322
7	18
8	15
9	30
10	155
11	3
13	4
14	5
15	1
16	4
17	2
18	1
20	4
21	1
23	2
24	1
25	9
26	1
27	1
28	1
30	3
31	1
32	1
35	3
36	1
40	1
44	1
45	5
50	4
52	1
55	8
56	1
60	2
65	1
70	1
75	1
80	1
90	1

这里我只想采取一行表中最高的



怎么能拿

here i want to take only one row that is highest in the table

how can take that

推荐答案

试试这个：

Try this:

SELECT  t2.day, t1.HighestCount
FROM (
    SELECT MAX(t1.count) AS HighestCount
    FROM TableName
)  AS t1 INNER JOIN TableName AS t2 ON t1.count = t2.count

或：

or:

SELECT day, count
FROM (
    SELECT day, count, ROW_NUMBER() OVER(ORDER BY count DESC) RowNo
    FROM TableName
) AS t
WHERE t.RowNo = 1

这篇关于如何在两列中选择最大值。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！