SQL Server 2017

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

CREATE TABLE #temp
(
Name NVARCHAR(200),
Code NVARCHAR(200),
Sequence NVARCHAR(200),
AutoIncrementId NVARCHAR(200)
)

INSERT INTO #temp VALUES ('Prashant',14323,1,11)
INSERT INTO #temp VALUES ('Prashant',14323,1,12)
INSERT INTO #temp VALUES ('Prashant',14323,1,13)
INSERT INTO #temp VALUES ('Prashant',14323,1,14)

INSERT INTO #temp VALUES ('Nishant',11323,2,11)
INSERT INTO #temp VALUES ('Nishant',11323,2,12)
INSERT INTO #temp VALUES ('Nishant',11323,2,13)
INSERT INTO #temp VALUES ('Nishant',11323,2,14)

INSERT INTO #temp VALUES ('Sushant',13223,3,11)
INSERT INTO #temp VALUES ('Sushant',13223,3,12)
INSERT INTO #temp VALUES ('Sushant',13223,3,13)
INSERT INTO #temp VALUES ('Sushant',13223,3,14)

INSERT INTO #temp VALUES ('Jishant',14223,4,11)
INSERT INTO #temp VALUES ('Jishant',14223,4,12)
INSERT INTO #temp VALUES ('Jishant',14223,4,13)
INSERT INTO #temp VALUES ('Jishant',14223,4,14)
16 rows affected

select *
from #temp


Name
Code
Sequence
AutoIncrementId


Prashant
14323
1
11

Prashant
14323
1
12

Prashant
14323
1
13

Prashant
14323
1
14

Nishant
11323
2
11

Nishant
11323
2
12

Nishant
11323
2
13

Nishant
11323
2
14

Sushant
13223
3
11

Sushant
13223
3
12

Sushant
13223
3
13

Sushant
13223
3
14

Jishant
14223
4
11

Jishant
14223
4
12

Jishant
14223
4
13

Jishant
14223
4
14


select Name, Code, Sequence as sequence, 
       convert(int, min(AutoIncrementId)) + convert(int, Sequence) - 1  as AutoIncrementId
from #temp
group by Name, Code, Sequence
order by sequence


Name
Code
sequence
AutoIncrementId


Prashant
14323
1
11

Nishant
11323
2
12

Sushant
13223
3
13

Jishant
14223
4
14

Name	Code	Sequence	AutoIncrementId
Prashant	14323	1	11
Prashant	14323	1	12
Prashant	14323	1	13
Prashant	14323	1	14
Nishant	11323	2	11
Nishant	11323	2	12
Nishant	11323	2	13
Nishant	11323	2	14
Sushant	13223	3	11
Sushant	13223	3	12
Sushant	13223	3	13
Sushant	13223	3	14
Jishant	14223	4	11
Jishant	14223	4	12
Jishant	14223	4	13
Jishant	14223	4	14