advertisement

Article:
  SQL Subqueries
Subject:   sql query
Date:   2005-12-09 00:00:58
From:   davaleswarapu
i had a table named production with columns names as machine,item,sdate,edate,qty.


i need a query in such a way that the qty of a item with respect to machine with its corresponding sdate and edates are consequtive is to be summed.