SQL (Structured Query Language)

What is SQL

SQL (Structured Query Language) is a standard language used for managing data in a relational database management system. Specific to roomMaster, SQL allows users to query their data and pull detailed information either in a ad-hoc query or by writing a report that can be run on demand.

Type of database used

When writing a SQL query, there are some nuances depending on the database being used. When writing a query in roomMaster, the database type is MariaDB. This may be helpful if you are learning SQL and need to understand which format to use. For users who previously wrote a query for roomMaster On Premise, when converted to roomMaster Cloud, some reports may need slight adjustments to work correctly.

For example, a report in roomMaster On Premise that displays the 10 most recent reservations could be written

SELECT TOP 10 RESERVE.CONFNUM,
       RESERVE.LASTNAME,
       RESERVE.FIRSTNAME
 
FROM RESERVE
ORDER BY RESERVE.CONFNUM DESC

The same report in roomMaster Cloud, would be slightly different.

SELECT RESERVE.CONFNUM,
       RESERVE.LASTNAME,
       RESERVE.FIRSTNAME
 
FROM RESERVE
ORDER BY RESERVE.CONFNUM DESC
LIMIT 10