SQL Query Question concerning math between rows
Posted by: jon silver
Date: June 20, 2014 03:13PM

I have a table with 3 columns: uniqueindex, userid and timestamp
There is an entry for each time a user submits a post.

I wanted to find
1. The average time between posts
2. users with posts within 10 minutes

is there any super type of query ? or do I need to write a function that cursors through each row by userid?

thanks,
jon

Options: ReplyQuote


Subject
Written By
Posted
SQL Query Question concerning math between rows
June 20, 2014 03:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.