[Solved] Select 2 maximum values in SQL with concatenation

by


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