ขนาดวิดีโอ: 1280 X 720853 X 480640 X 360
แสดงแผงควบคุมโปรแกรมเล่น
เล่นอัตโนมัติ
เล่นใหม่
with cte as(select orderss.*,DENSE_RANK()OVER(PARTITION BY customer_id ORDER BY order_date DESC) as r1 FROM orderss),cte1 as(select customer_id,order_amount as latest_order_amount,order_date FROM cte where r1
Good job 👍
with cte as(
select orderss.*,DENSE_RANK()OVER(PARTITION BY customer_id ORDER BY order_date DESC) as r1 FROM orderss
),cte1 as(
select customer_id,order_amount as latest_order_amount,order_date FROM cte where r1
Good job 👍