Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions in MS SQL Server

Evaluation Order and Common Problems
Window functions and GROUP BY
Summary and Review

Instruction

In this part, we'll keep things simple by only working with a single table – Auction. Let's get to know it.

Exercise

Select all columns from the Auction table.

The table stores information about past Internet auctions from a certain online auction website. You can see the following columns:

  • Id – A unique ID for each auction
  • CategoryId – An ID of the type of auction, e.g. furniture, medical supplies, etc.
  • AskingPrice – The initial price set by the seller
  • FinalPrice – The highest bid paid to the seller
  • Views – The number of views for that auction
  • Participants – The number of users who took part in that auction
  • Country – The country of that auction
  • EndDate – When the auction ended and the item was sold