Home
UCI Health
Enterprise
Requests
Explorer
Notebooks
Scratchpad
SQL
Logs
SQL Scratchpad
Run ad-hoc queries against a deployment database.
Select deployment
Limit
Execute
⌘+Enter to run
SELECT TOP 10 dx.DX_ID, edg.DX_NAME, edg.DX_GROUP, edg.CURRENT_ICD10_LIST, edg.CURRENT_ICD9_LIST FROM PAT_ENC_DX dx JOIN CLARITY_EDG edg ON dx.DX_ID = edg.DX_ID