Hi,
I need a query to update first row per each group with a vale of 1.
Example:
table1 have below fields
ID marks cnt
1 34
1 22
2 44
2 4
2 5
6 7
after query output should be
ID marks cnt
1 34 1
1 22
2 44 1
2 4
2 5
6 7 1
Please let me know your inputs. Advance Thanks