Thursday, 10 October 2013

7. Display the Order ID of the top five orders based on the total amount due in the year 2001. (Use the AdventureWorks database)

select Top 5 salesorderId from sales.salesorderHeader
where Datepart(yyyy,orderDate)=2001 order by totalDue desc
at
Labels:

1 comment:

  1. Unknown5 March 2022 at 02:29

    This website is very good for student of us that that studying IT under NIIT
    This website help most to do my database SQL assignment thank you.

    ReplyDelete

Subscribe to: Post Comments (Atom)