ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  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.