Basic Window Functions

devstronomy_basic_window_functions.sql

select p.name,
       row_number() over () rn,
       rank() over () rnk,
       dense_rank() over () dns_rnk,
       lead(p.name) over () lead_name,
       lag(p.name) over () lag_name,
       first_value(p.name) over () fv_name,
       last_value(p.name) over () lv_name,
       ntile(4) over () quartile,
       ntile(5) over () quintile
  from devstronomy.planet as p;