Hakan Axheim

Hakan Axheim

  • 2k
  • 194
  • 19.7k

Help with SQL query needed

Aug 27 2020 6:22 AM
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.

Answers (1)