Home » RDBMS Server » Server Administration » Urgent sql query
Urgent sql query [message #373516] Fri, 20 April 2001 08:08 Go to next message
CHACKO
Messages: 11
Registered: March 2001
Junior Member
How can I retrieve data in weekly basis?
For eg:
From Jan 01,2000 to till present

Any help is appreciated
Thanks

Report message to a moderator

Re: Urgent sql query [message #373517 is a reply to message #373516] Fri, 20 April 2001 08:15 Go to previous messageGo to next message
Miguel
Messages: 14
Registered: April 2001
Junior Member
Something like this:

select *
from XXX
where trunc(revised_date) >= trunc(sysdate-7)

This will grab data where a revised_date
is 7 days old or newer.

HTH

Report message to a moderator

Re: Urgent sql query [message #373550 is a reply to message #373516] Mon, 23 April 2001 09:47 Go to previous messageGo to next message
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hi,

The solution for your problem is Procedure.

If u r interested in procedure, let me know that.

I will send the procedure to u. my mail id is

balus77@rediffmail.com

Cheers,
Balu

Report message to a moderator

Re: Urgent sql query [message #373558 is a reply to message #373516] Mon, 23 April 2001 11:27 Go to previous message
Jaco
Messages: 23
Registered: August 2000
Junior Member
Ok balu, please send me the procedure for this problem. Is it possible to write function for this problem

Report message to a moderator

Previous Topic: Query a column and remove everything after the space
Next Topic: how do u I write this sql query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 15:49:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.