davard Posted August 7, 2007 Share Posted August 7, 2007 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? Link to comment https://forums.phpfreaks.com/topic/63764-solved-using-max-in-the-where-clause/ Share on other sites More sharing options...
davard Posted August 7, 2007 Author Share Posted August 7, 2007 Nevermind, got it Link to comment https://forums.phpfreaks.com/topic/63764-solved-using-max-in-the-where-clause/#findComment-317829 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.