例如
col1 col2 col3 col4
1 2 3 4
q 2 r 5
w 4 r 4
w 5 r 4
要找到clo2相同 col4值最大的行
sql:
select
distinct on(clo2)
clo2, clo4
form table
order by clo2 , clo4 desc
例如
col1 col2 col3 col4
1 2 3 4
q 2 r 5
w 4 r 4
w 5 r 4
要找到clo2相同 col4值最大的行
sql:
select
distinct on(clo2)
clo2, clo4
form table
order by clo2 , clo4 desc
转载于:https://my.oschina.net/fishyufeng/blog/373271