Do you want to get the compatibility Level of rour DB using a single Query?

Easy to do:

SELECT

dtb.compatibility_level AS [CompatibilityLevel],

dtb.name AS [DatabaseName2]

FROM

master.sys.databases AS dtb

WHERE

(dtb.name='master')

The result of this query will give us the Compatibility Level of this database.