Essentially it is exactly as in the title. I'm thinking for a potential workaround of a larger query.
Is it possible given:
Name...Empl__ID
John.....101
John.....101
John.....101
To create a query which adds a column which places either a number 1 against only one of these records or sequentially numbers them?
What I want is
Name...Empl_ID...Number
John.....101..........4
John.....101..........3
John.....101..........2
John.....101..........1
The key idea is to make it so there is one distinct record I can define by this number. So even just putting 1 number next to one record is fine. I know in this instance it'd be simpler to use select distinct, but unfortunately in reality the data has some other key information which prevents that. See the image if you'd like more of an idea
.
Thanks!