Hello,
I am having a table looking like this:
-------------------------------------
PersID | Name | RoomID |
-------------------------------------
Some of the data rows have identical PersID and Name, but differ in
the RoomID.
Now I want to create a select statement, which gets only the first
row, if there are more
than one row where PersID and Name are the same.
E.g.:
-------------------------------------
PersID | Name | RoomID |
-------------------------------------
1 |John | 234
2 |Alice | 345
2 |Alice | 456
3 |Bob | 789
The result table of my select statement should be:
-------------------------------------
PersID | Name | RoomID |
-------------------------------------
1 |John | 234
2 |Alice | 345
3 |Bob | 789
How do I do that? I
Regards,
Martin