MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t1(id int,groupname varchar(10))
insert into t1 values(1,'g1'),(2,'g1'),(3,'g2'),(4,'g2')
select b.id,b.groupname,count(b.id) as val from t1 a
join t1 b on a.groupname=b.groupname
and a.id<=b.id
group by b.id,b.groupname


id
groupname
val


1
g1
1

2
g1
2

3
g2
1

4
g2
2


select to_date('01-06-17') from dual
FUNCTION fiddle_HKQHWNBTGGYEDXTCLBSE.to_date does not exist

SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual
FUNCTION fiddle_HKQHWNBTGGYEDXTCLBSE.TO_DATE does not exist

SELECT TO_DATE('01-06-17', 'DD-MM-RR') FROM dual
FUNCTION fiddle_HKQHWNBTGGYEDXTCLBSE.TO_DATE does not exist

select replace('034521123455',left('034521123455',2),'+92')


replace('034521123455',left('034521123455',2),'+92')


+924521123455