Sort based on column 1, not working with awk

Shell Programming and Scripting
1

Hi Guru,
I need some help regarding awking the output so it only show the first line (based on column) of each row.

So If column has 1, three row, then it only show the first line of that row, based on similar character in column 1. So i am trying to achieve a sort, based on column one and only show the first line.

I used the follownig command - awk NF==1'{print $2,$9}', but naturally this is giving the wrong output.

See below.

Output

1 CAG760
1 CAG123
1 CAI000
2 CBH628
2 CBI123
2 CBH630

Output Required

1 CAG760
2 CBH628
2 
$ awk '{ if (L!=$1) print; L=$1}' inputfile
1 CAG760
2 CBH628
3

Worked a treat thanks.

4

Another approach:

awk '!A[$1]++' file