Skip to content

Instantly share code, notes, and snippets.

@glandaverde
glandaverde / sql_id_time_waited.sql
Created November 10, 2015 16:54
sql_id_time_waited
SELECT
INST_ID,event,
time_waited "time_waited(s)",
case when time_waited = 0 then
0
else
round(time_waited*100 / sum(time_waited) Over(), 2)
end "percentage"
from
(