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

Home -> Community -> Usenet -> c.d.o.server -> Re: Need Help with another SQL query

Re: Need Help with another SQL query

From: José Lima Suárez <pplima_at_jet.es>
Date: 1998/04/18
Message-ID: <6hafu4$el7$1@diana.bcn.ibernet.es>#1/1 







try this:



select project_id, count(*)


from table


where end_date between sysdate - 6 and sysdate;
Received on Sat Apr 18 1998 - 00:00:00 CDT












Original text of this message













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