Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Getting max date from min date

DipNov 28 2007 — edited Nov 28 2007
Hello.

We have a problem with getting max values out of min values.

Example (table):
date.....................type
27.11.07 06:00........1
27.11.07 10:00........2
27.11.07 10:00........1
27.11.07 10:30........2
27.11.07 10:45........1
27.11.07 15:00........2

Max value is max time with type 1. In this case, max is at time 10:45.
Min value is max time with type 2, which must be smaller than max time with type 1.

So we have 10:45, which is good. And we need 10:30.
But we get two values for min. That is 10:00 and 10:30.

How can we solve that?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2007
Added on Nov 28 2007
6 comments
8,403 views