delete a duplicate line or triplicate line and keep one

Delete duplicate items in table:

I have a table with a field called [LINEITEMID]

IT CONTAINS DUPLICATES

SELECT [PROJECTID]
      ,[SUBMITDATE]
      ,[STARTDATE]
      ,[AUDITEDDATE]
      ,[PROJECTTYPE]
      ,[PROJECTPROORRE]
      ,[ACCOUNTNUMBER]
      ,[NOOFLINEITEMS]
      ,[ACCOUNTTYPE]
      ,[SKU]
      ,[SEARCHSTATUS]
      ,[U_TYPE]
      ,[UPDATEDBY]
      ,[NOOFBOTHMFGPRESENT]
      ,[NOOFDESCRIPTION]
      ,[NOOFGRAINGERSKU]
      ,[NOOFMFGNAME]
      ,[NOOFMFGPARTNUMBER]
      ,[NOOFSPELLERRORMFGNAME]
      ,[AVGNOOFWORDSPERLINE]
      ,[ACCTTYPE]
      ,[PARENTTRACKCODE]
      ,[ADMINCONVERTEDDATE]
      ,[ADMINLINECONVERSION]
      ,[ADMINTIME]
      ,[ADMINRACFID]
      ,[COMPANYNAME]
      ,[CRMACCOUNTTYPE]
      ,[ADMINCONVERSIONTYP]
      ,[SLATYPE]
      ,[AUTOMATCH]
      ,[POSTCOUNTS]
      ,[MANUALMATCH]
      ,[EXCPETION_DIRECT]
      ,[AUDITEDBY]
      ,[ASSIGNEDBY]
      ,[PROJECTASSIGNTO]
      ,[QUALIFIEDLINES]
      ,[QUEUEACCOUNTTYPE]
      ,[QUEUENAME]
      ,[SEGMENT]
      ,[SELLERSRACFID]
      ,[SLADATE]
      ,[SPLITPROJECT]
      ,[STATUS]
      ,[TOTAL_EXPENSE]
      ,[BRANDNUMBER]
      ,[LASTMODIFIED]
      ,[LINEITEMID]
      ,[LINEITEMRESID]
      ,[MATCHEDROWID]
      ,[MFGNAME]
      ,[MFGPARTNUMBER]
      ,[MGRCODE]
      ,[POSTTYPESEARCH]
      ,[SALESSTATUS]
      ,[SUPPLIERNUMBER]
      ,[UPDTTYPE]
  FROM [Metrics].[dbo].[ORACLE_EXT]
  
  where [LASTMODIFIED] >= '2019-01-01'

Select allOpen in new window

What I need I need to dlete the duplicate line but keep one good ;line


The data looks like this

[LINEITEMID]
2234
2235
2236
2236
2237
2237
2237
2238
2239
2240...etc..

Thanks
fordraiders