Counting Records - SQL Server 2000
I need to count rooms sold. The problem is that a room can be sold more than once for any given trip. How can I retrieve all records including one instance where the room has been sold multiple times on a given trip?
Inv. Trip Room
1 A50805 201
2 A50805 202
3 B60805 201
4 B60805 201
The query should return records 1, 2, 3.
Any help greatly appreciated!