select t, d,
count(*) over() cnt,
row_number() over(order by t) rn_by_t,
row_number() over(order by d) rn_by_d,
max(d) over(partition by t) max_by_t,
sum(d) over() total_d
Open in new window
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.