ID | COMPANY_ID | EVENT_ID
Each are numeric, ID is auto inc.
I'm trying to use the following query:
Code: Select all
SELECT ID,COMPANY_ID,EVENT_ID FROM my_table WHERE COMPANY_ID = 2Code: Select all
Data in Table
ID COMPANY_ID EVENT_ID
1 1 3
2 1 4
3 2 3
4 1 1
5 2 3
6 3 3
7 2 1Code: Select all
ID COMPANY_ID EVENT_ID
3 2 3
5 2 3
7 2 1*Field COUNTER would increment with each row.
My desired result:
Code: Select all
ID COMPANY_ID EVENT_ID COUNTER
3 2 3 1
5 2 3 2
7 2 1 3