Skip to content

Instantly share code, notes, and snippets.

@ramannanda9

ramannanda9/analytic.sql

Created July 20, 2016 01:17
Show Gist options
  • Save ramannanda9/732ab0ec953ca36d3d03122ac9780bcd to your computer and use it in GitHub Desktop.
Save ramannanda9/732ab0ec953ca36d3d03122ac9780bcd to your computer and use it in GitHub Desktop.
Download ZIP
analytic function
Raw
analytic.sql
select empno, deptno, row_number() over (partition by deptno order by 1) sequence_num from scott.emp;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment