Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL calcul

SQL calcul

From: gil guerillot <gil.guerillot_at_ratp.fr>
Date: Tue, 21 May 2002 14:49:11 +0100
Message-ID: <acdfn6$24er$1@gotix.reseau.ratp> 





i' ve already ask for this question but i was probably not very clear



i have one table



object_code


object_category


date_buy


date_broken




i want to know for every year and by object_category the number of object in
life (year between date_buy and date_broken)



like this


year

       category
                     count(object_code)






and also when no object of a category is buy or broken in a year
Received on Tue May 21 2002 - 08:49:11 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US