Advertisement
Guest User

Untitled

a guest
Apr 24th, 2017
13
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.15 KB | None | 0 0
  1. select *
  2. from (
  3. select parameter, value, year, LAG(value, 1)
  4. over (order by your_order_by_column) pre_value from T_TABLE)
  5. where pre_value <> value;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement