Untitled

 avatar
unknown
plain_text
2 years ago
353 B
5
Indexable
WITH RankedRows AS (
  SELECT NrProjektu + '-' + Firma as ind, NazwaOdbiorcy,
         ROW_NUMBER() OVER (PARTITION BY NazwaOdbiorcy ORDER BY NrProjektu) AS RowNum
  FROM WASKO_DAX2009_PROD.dbo.Projekty2JIRA
)
SELECT ind, NazwaOdbiorcy
FROM RankedRows
WHERE RowNum = 1 AND lower(NazwaOdbiorcy) like concat(lower(?),'%') ORDER BY NazwaOdbiorcy ASC
Editor is loading...