0

查看全部 5 个回答

0

select * from table order by TIME desc

推荐答案

0

已采纳
SELECT * FROM (
  select t.*, row_number() over(partition by trunc(buy_time), good_id order by buy_time desc) AS row1
  from TMP_T1 T
) WHERE row1 = 1