Querying the occurence of rows without group by

[mvilrokx]

Hi,

I am wondering if the following is possible in an SQL Query:

Consider the following Table

TABLE1 =

ID NAME
--- ----
102 JOEL
256 MARK
269 MARK
270 JOSH
369 AMY
699 AMY


SELECT NAME, occurence
FROM TABLE1

The result would be

NAME occurence
---- ---------
JOEL 1
MARK 1
MARK 2
JOSH 1
AMY 1
AMY 2

Cheers,
M.

[jmodic]

select 
  name,
  row_number() over
   (partition by deptno order by id) as occurence
from table1;

[mvilrokx]

Absolutely fantastic, thanks