s******e
发帖数: 841 | 1 I just started learning SQL. I could not figure out how to get the results
as shown in the attached picture. Can anyone give me some hints?
Thanks in advance |
c*******e
发帖数: 8624 | 2 select *
from your_table
qualify row_number() over (partition by column1 order by column3 desc) = 1 ;
【在 s******e 的大作中提到】
: I just started learning SQL. I could not figure out how to get the results
: as shown in the attached picture. Can anyone give me some hints?
: Thanks in advance
|
B*****g
发帖数: 34098 | 3 我早就说这个应该置底，为sql问题先看partition by
;
results
【在 c*******e 的大作中提到】
: select *
: from your_table
: qualify row_number() over (partition by column1 order by column3 desc) = 1 ;
|
j*****n
发帖数: 1781 | 4 re
【在 B*****g 的大作中提到】
: 我早就说这个应该置底，为sql问题先看partition by
:
: ;
: results
|
