Free for PREMIUM members
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
TO_NUMBER(SUBSTR(RAWTOHEX(maxrole), 1, 20), RPAD('x', 20, 'x')) + 1,
RPAD('fm0', 22, 'X')
|| SUBSTR(RAWTOHEX(maxrole), 21)) next_role
FROM ( SELECT job_id, MAX(role_id) maxrole
GROUP BY job_id)
Open in new window
Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.