how to get the unique row

[qwang1115]

I have a table with following data

1 a
2 b
3 c
4 a
5 d
3 b

how to get the unique row which is 5/d

Thanks!

 

[jwhite]

One can guess, but how about provide some details what the meaning of the two fields are about and what explicitly makes 5/d the unique choice?

 

[qwang1115]

One can guess, but how about provide some details what the meaning of the two fields are about and what explicitly makes 5/d the unique choice?

This is the question when I go for an job interview. So I don't know the meaning of the two fields.

Since 1/a and 4/a have the same value "a", so these 2 rows are not unique; 2/b and 3/b are the same; 3/c and 3/b have the same value "3". So only 5/d is the unique row, because 5 and d are not duplicated.

Thanks!

 

[jwhite]

Okay, so the employer let you take the Job Interview Test home with you?