| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Tricky Query
Hi All,
I am working on a application in which I have to find the Min and Max time of the user session. Since there will be multiple records for a single session with the overlapping time. the example data is as foll.
MMCR_APPNO MMCR_START_TIME MMCR_END_TIME
------------------ -------------------- ------------------ 10000 10 30 10000 20 40 10000 40 45 10000 10 50 10000 60 80 10000 70 90 10000 65 100 10000 110 120 10000 105 140
expected result
MMCR_APPNO MMCR_START_TIME MMCR_END_TIME
------------------ -------------------- ------------------ 10000 10 50 10000 60 100 10000 105 140
the comparision has to be done on end time not lying between starttime and endtime of the next record if it does then the user belong to same session....
cheers
Swajit
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Swajit Satam
INET: swajit_at_mahindrabt.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 15 2001 - 06:20:29 CST
 |
 |