SQL Query Question concerning math between rows
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
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.