SQL小白求教，如何查出時(shí)間靠后的訂單

select * from table order by TIME desc

select goodid, max(time) from table group by goodid
用商品goodid分組 "group by goodid" 然后取time最大值 MAX(TIME)

select max(TIME) , GOODID from product group by GOODID

先排序后分組不行嗎

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