We've expanded our news coverage and improved our search! Visit news.oreilly.com for the latest or search for all things across O'Reilly!
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.