Need SQL Query

[Gabrel]

Hello,
Consider the following table:

Select * from tblTest;

coloumn1	value
y	3
z	1
x	2

How should I write the SQL statement to get the output as follows:

coloumn1	value
x	1
y	2
z	3

Please help guys.

[KelvinSmith]

Hi Gabrel,

Try following SQL statement.

With T As
(Select coloumn1 , value, RowNumber() Over (Order By coloumn1) R1 From tblTest),
T1 As
(Select coloumn1, value , RowNumber() Over (Order By value) R2 From tblTest)
Select T.coloumn1 , T1.value From T, T1 Where R1 = R2;