Hi,
I have a table with two columns where I have following data;
A9
A8
A7
A6
A5
A4
A3
A2
A1
B9
B8
B7
B6
B5
B4
B3
B2
B1
C12
C11
C10
C9
C8
C7
C6
C5
C4
C3
C2
C1
I need an SQL that gives me following result:
A9
B9
C12
Maybe someone can help me with an SQL query that gives me the result I want.
I work in SQL Server.