Closed saikoneru1997 closed 1 day ago
select customerid,order,orderdate,lag(orderdate) over(partition by customerid order by orderdate) as preveous_order from order
Can you write a query to get the next order date for each customer?"
select customerid,order,orderdate,lead(orderdate) over(partition by customerid order by orderdate) as last_order from order
select customerid,order,orderdate,lag(orderdate) over(partition by customerid order by orderdate) as preveous_order from order
Can you write a query to get the next order date for each customer?"
select customerid,order,orderdate,lead(orderdate) over(partition by customerid order by orderdate) as last_order from order