Help with SQL query needed

Question

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.