OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » HELP WANTED

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HELP WANTED [message #235849]

Tue, 08 May 2007 02:52

thomas.dobslaff
Messages: 2
Registered: May 2007

Junior Member

HEllo i'm Thomas and I'm new in this forum.
I really need your help!

I have a table with a date coulumn. Everey minuite a new row is insert. Now I want to make a select where I can get each row every 10 minuites.

I hope you understand me an you can help me!

Thomas

Report message to a moderator

Re: HELP WANTED [message #235859 is a reply to message #235849]

Tue, 08 May 2007 03:25

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't really understand what you mean.
Do you want one row out of 10?

Please read How to get a quick answer to your question: TIPS AND TRICKS.
Please read How to format your posts.
Please post your full Oracle version.
Please post a test case (create table for you table, insert statements for sample data).

Regards
Michel

Report message to a moderator

Re: HELP WANTED [message #235863 is a reply to message #235859]

Tue, 08 May 2007 03:32

thomas.dobslaff
Messages: 2
Registered: May 2007

Junior Member

thanks for your quick answer.

look
I have for example this rows

07.05.2007 08:04 ....
07.05.2007 08:05 ....
07.05.2007 08:06 .....
07.05.2007 08:07 ....
07.05.2007 08:08
07.05.2007 08:09
07.05.2007 08:10
07.05.2007 08:11
07.05.2007 08:12
07.05.2007 08:13
07.05.2007 08:14
07.05.2007 08:15
07.05.2007 08:16
07.05.2007 08:17
07.05.2007 08:18
07.05.2007 08:19
07.05.2007 08:20

and now I want to select e.g.
row 07.05.2007 08:04
row 07.05.2007 08:14
row 07.05.2007 08:24

and so on. Like you see: every 10th minuite

Report message to a moderator

Re: HELP WANTED [message #235865 is a reply to message #235863]

Tue, 08 May 2007 03:39

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read the links I posted and answer ALL the questions we ask.
If you persist to not read and apply them, you will no more have help.

You can do something like:
select * from mytable
where mod(extract(minute from mydate),10) = 4
/

It's just an example, of course.

Regards
Michel

Report message to a moderator

Previous Topic:	Update query is not working ?
Next Topic:	Meaning of these two tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 16 19:25:40 CST 2025