[Solved] Select 2 maximum values in SQL with concatenation

by

[ad_1]

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

[ad_2]

solved Select 2 maximum values in SQL with concatenation