[Solved] Resulting data on last thread_date
I got this fixed by creating a PHP function to return the latest thread with a SELECT * FROM threads WHERE subcat_id = variable SQL. 1 solved Resulting data on last thread_date
greatest-n-per-group
[Solved] Select 2 maximum values in SQL with concatenation
Try this, SELECT HOTELNAME , ROOMTYPE , CONCAT(NIGHTS,’ NIGHTS ‘,ACCESSIBILITY) AS NUM_OF_NIGHTS FROM HOTEL, ROOM, BOOKING WHERE ACCESSIBILITY=’N’ OR ROOMTYPE=’DOUBLE’ ORDER BY NIGHTS DESC LIMIT 2 2 solved Select 2 maximum values in SQL with concatenation
[Solved] mySQL Fetch the row which has the Max value for a column
First, you shouldn’t name your column update, choose another name, let’s say “date_of_update” If you want to select only the row with the most recent update, you can simply use something like this : SELECT * FROM table_name ORDER BY date_of_update DESC LIMIT 1. This will give you only one row with the max date! … Read more