CREATE VIEW dbo.PLASIYERLER_GIDER_SIRALI
AS
SELECT QQ.PLAS , ROW_NUMBER() OVER (ORDER BY QQ.PLAS) AS SIRA  FROM
(
SELECT        replace([SPECODE2],'G','G') AS PLAS 

FROM            [UNIVERSALDB].[dbo].[PLAS_LIST])QQ
WHERE QQ.PLAS<>'HAKAN'
GROUP BY QQ.PLAS