Posted by Sandy on 10/08/99 11:32

Hi,

I have a table A (ID, time,...)

first I want to select rows with max value of time. Then from these rows I
want the row with max ID value.
i am doing the following but its giving me the error mentioned below

select max(ID) from (select * from A where time in ( select max(time) from
A ) )
ERROR: Incorrect syntax near ')'

Where is the problem in my Query. Is there any other way to do this??

any help is greatly appreciated.

Thanks

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

[Reply to this message]