Posted by Jens on 10/20/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.

• Next in forum: Re: UBOUND
• Prev in forum: problem with Select query
• Thread view: Re: problem with Select query

[Reply to this message]