a guest Jan 22nd, 2019 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT sum(cumneg * label) * 1e0 / (sum(label) * sum(1-label)) AS auc
  2. FROM (
  3.   SELECT label,
  4.     sum(1-label) OVER(ORDER BY confid ROWS UNBOUNDED PRECEDING) (BIGINT) cumneg
  5.   FROM T
  6. ) t;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand