even easier 😉

DECLARE @table TABLE

(

[Key] VARCHAR(50),

Value VARCHAR(50)

)

INSERT INTO @table

SELECT 'firstname', 'surya'

UNION ALL SELECT 'firstname', 'rakhi'

UNION ALL SELECT 'firstname', 'venkat'

UNION ALL SELECT 'firstname', 'shankar'

UNION ALL SELECT 'firstname', 'dany'

SELECT

[value] AS FirstName

FROM

@table

ORDER BY

[Value]