Home » SQL & PL/SQL » SQL & PL/SQL » HELP WANTED
HELP WANTED [message #235849] Tue, 08 May 2007 02:52 Go to next message
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
Re: HELP WANTED [message #235859 is a reply to message #235849] Tue, 08 May 2007 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: HELP WANTED [message #235863 is a reply to message #235859] Tue, 08 May 2007 03:32 Go to previous messageGo to next message
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

Re: HELP WANTED [message #235865 is a reply to message #235863] Tue, 08 May 2007 03:39 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Update query is not working ?
Next Topic: Meaning of these two tables
Goto Forum:
  


Current Time: Sat Dec 10 06:46:44 CST 2016

Total time taken to generate the page: 0.14334 seconds