PostgreSQL: PostgreSQL JSONB query #47
Toolliyo Coach
Progressive help: Nudge → Guide → Approach. Full solution stays behind the Solution tab.
Editor is open — no login wall to practice.
| Test | Status | Details |
|---|
Ready — edit the code above and click Run or Submit.
-- JSONB column example
SELECT data->>'city' AS city
FROM profiles
WHERE data @> '{"active": true}'::jsonb;Prefer Coach (Nudge → Guide → Approach) before revealing. No forced signup.
PostgreSQL: CTEs, window functions, ILIKE, JSONB @>, EXPLAIN ANALYZE.
Sign in to save and review your submission history. You can still Run code on the Editor tab as a guest.
Sign in