Skip to content

Instantly share code, notes, and snippets.

View whitekatanasharp's full-sized avatar

whitekatanasharp

View GitHub Profile
@whitekatanasharp
whitekatanasharp / gist:1e7b7e2cbfc9dcaf44fe6ab8798b2a84
Last active October 20, 2025 08:04
Полуфинал Базы данных (PostgreSQL)
--Б1.
SELECT ao.* FROM gar.adm_hierarchy as ah
INNER JOIN gar.address_objects as ao ON ah.objectId = ao.objectId
WHERE ah.parentobjid = 1325538 AND ah.isactive AND ao.isactive
AND ao.typename = 'ул' AND ao.name ILIKE 'Л%'
ORDER BY ao.name ASC
--Б2.
WITH a AS (
SELECT objectid,