Hi,
I'm trying to write a query which pulls the distinct records from a table.
I've a table which has a primary key column(ID). One more significant field is move_id.Except the PK field all other fields are duplicated for some rows. But for each distinct move_id I've couple of rows with different PK values. But from which I want only one(any one).

Table Test:
ID move_id name ....
1 'xx' 'pp'
2 'xx' 'pp'
3 'xx' 'pp'
4 'yy' 'uu'
5 'yy' 'uu'

I'm trying to write a query which gives me

1 'xx' 'pp'
2 'yy' 'uu'
....

Thanks,
kkr