distinct row from the table
how do we select distinct no,code in each row from the below table :-
select * from testing
NO CODE NAME
----------- ----------- ----
12 25 A
12 24 A
13 24 B
13 24 B
12 25 A
13 24 C
select distinct(NO) ,CODE from testing .it works
NO CODE
----------- -----------
12 24
13 24
12 25
when I add one more columns it doe's not give distinct output
select distinct(NO) ,CODE,NAME from testing
NO CODE NAME
----------- ----------- ----
12 24 A
12 25 A
*13 24 B*
*13 24 C*