Re: Retrieving first row of a query in Oracle SQL

> SELECT id, dat, cnt, stuff
> FROM T
> WHERE (cnt,dat) IN (
> SELECT MIN (cnt), MIN(dat)
> FROM T
> WHERE dat = (
> SELECT MIN(dat)
> FROM T
> )
> )

That isn't simpler either. Actually, the innermost WHERE clause is redundant, isn't it? Received on Thu Aug 30 2007 - 01:30:38 CDT