02. Display SalesOrderID, OrderQty, and UnitPrice from the SalesOrderDetail table where a similar unit price needs to be marked with an identical value.
select salesOrderID,OrderQty,UnitPrice,Dense_Rank() Over(Order by UnitPrice ASC) as Rank from sales.salesOrderDetail
No comments:
Post a Comment