SHARE
TWEET

Untitled




Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT
- CAST(CASE
- WHEN a = b
- THEN i
- ELSE i+1
- END AS bit) as id
- FROM mytable
- SELECT a, b, sum(i) over(order by x) as id
- FROM (
- SELECT a, b, CASE WHEN a = b THEN 1 ELSE 0 END as i
- FROM mytable
- ) x
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.