SELECT TO_DATE(MIN(logintime),'dd-mon-yyyy')-TO_DATE(MAX(logintime),''dd-mon-yyyy'')*24*60 FROM my TABLE WHERE studentno=202050 AND TRUNC(logintime)='21-MAY-2002'
|
Results 1 to 8 of 8
Thread: query help
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote