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 -> 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