Try the SQL workspace

Retired RMS, CAD and evidence tables

Anytown Police Department · Records
View as

Try a question

SQL workspaceRecords clerk

Sources

Retired RMS

Retired CAD

Evidence system

rms_arrest

Columns

    Prebuilt queries on rms_arrest.DOB

    Each one opens its SQL in a new tab without running it. Join skeleton adds to the current tab.

    Query editor

    Confirm your sign-in to open the query editor

    The editor opens for staff with the SQL permission, on a session signed in with a second factor. In this demo, one click confirms it.

    Suggested joins

      Overlap checks are bounded and return counts, never values. You confirm a join in the editor, or dismiss it.

      Activity

      1. No runs yet.

      Pick a table or a column, open a prebuilt query, then run it as either role.Open the full demo