SQL Server 2022

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

CREATE TABLE [dbo].[testTable](
    [SectionID] [int] IDENTITY(1,1) NOT NULL,
    [SectionName] [varchar](1000) NULL,
    
 CONSTRAINT [PK_SectionNomination] PRIMARY KEY  ( [SectionID] )
);

-----

SET IDENTITY_INSERT dbo.TestTable ON;

INSERT INTO dbo.TestTable ( SectionName, SectionId )
  VALUES
  ( 'TestSection1', 34 ),
  ( 'TestSection1', 35 ),
  ( 'TestSection3', 36 ),
  ( 'TestSection3', 37 ),
  ( 'TestSection4', 38 );

SET IDENTITY_INSERT dbo.TestTable OFF;
5 rows affected

  select
      max(SectionId) as pID
  from
      testTable 
  group by
      SectionID;

SELECT
  SectionName,
  SectionId
FROM
  dbo.TestTable pt, 
  (
  select
      max(SectionId) as pID
  from
      testTable 
  group by
      SectionID
  ) st
where
  pt.SectionID = st.pID


pID


34

35

36

37

38




SectionName
SectionId


TestSection1
34

TestSection1
35

TestSection3
36

TestSection3
37

TestSection4
38


    SELECT
      s.SectionName,
      MAX( s.SectionId ) AS MaxSectionId
    FROM
      dbo.TestTable AS s
    GROUP BY
      s.SectionName


SectionName
MaxSectionId


TestSection1
35

TestSection3
37

TestSection4
38

SectionName	SectionId
TestSection1	34
TestSection1	35
TestSection3	36
TestSection3	37
TestSection4	38