Posted by Jens on 09/25/96 11:32

This could be a solution:


Select MAX(ID) FROM SomeTable
Where Time =
(
Select MAX(Time) From SomeTable
)

You were missing the aliases:


select max(ID) from
(
select * from A where time in
(
select max(time) from A
) SubQuery1
) SubQuery2


HTH, Jens Suessmeyer.

[Back to original message]