[SOLVED] Using MAX() in the WHERE clause

[davard]

Getting an error when trying to do something like this:

 

select * from table where field<max(field)

 

Simple idea; select everything apart from the rows that have the largest value in one of the fields, but Mysql returns: "#1111 - Invalid use of group function". What's wrong/what should the query be?

[davard]

Nevermind, got it