SQL help

[jacobelias]

Hi,

The following query works fine in SQL Server, however in
MySQL it''s not working?

select * from indexvalues where indexdate in(select max(indexdate)
as indexdate from indexvalues)

Thanks

Jc

[thoand]

Not so familiar with SQL server, but why not do:

"SELECT * FROM indexvalues ORDER by indexdate DESC LIMIT 1"

regards,
Thomas A.

[jacobelias]

Thanks a lot and much appreciated.

Jc