I am launching this query using Sequel Pro:
select MAX (price) from t_hotel_price group by hotel_id
but I got this error
FUNCTION hotels.MAX does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
Asked
Active
Viewed 135 times
0
Ramon De Les Olives
- 657
- 2
- 6
- 8
-
Try: `select MAX(price) from t_hotel_price group by hotel_id`. See [9.2.4 Function Name Parsing and Resolution :: Built-In Function Name Parsing](https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html#function-name-parsing). – wchiquito Jan 21 '18 at 18:10
-
please convert to answer ! – Ramon De Les Olives Jan 21 '18 at 20:32