Skip to main content

Posts

Showing posts from 2023

T-SQL LEAD LAG and SUM function based query

  Query on T-SQL window clause Below is the sales table Order_Date Name Product SubCategory Category Quantity SalesAmount DiscountAmount 10-08-2011 Megan Stewart Mountain-100 Silver, 38 Mountain Bikes Bikes 1 3399.99 0 14-09-2011 Elizabeth Clark Mountain-100 Silver, 38 Mountain Bikes Bikes 1 3399.99 0 14-10-2011 Olivia Torres Mountain-100 Silver, 38 Mountain Bikes Bikes 1 3399.99 0 20-10-2011 Ethan Foster Mountain-100 Silver, 38 Mountain Bikes Bikes 1 3399.99 0 14-11-2011 Beth Gutierrez Mountain-100 Silver, 38 Mountain Bikes Bikes 1 3399.99 ...