Help With Select Query

Databases
1

First of all the table and data:

Time Date Name Result

13:00 01 Jan 2010 Name01 Profit
13:30 01 Jan 2010 Name02 Profit
13:30 01 Jan 2010 Name02 Loss
14:30 01 Jan 2010 Name03 Loss

What I want to do is display these results, however for the record that is duplicated (Name02) I only want to show the ‘Profit’ row.

So the query would end up with the following:

13:00 01 Jan 2010 Name01 Profit
13:30 01 Jan 2010 Name02 Profit
14:30 01 Jan 2010 Name03 Loss

The end result is to be displayed within a DataList (dont know if it can be omitted after the SQL query). Would appreciate any help.

2

I think

time column is 13:00, 13:30 etc

date column is ‘01 Jan 2010’

name column is ‘Name01’ etc

result column is ‘profit’ or ‘loss’

3

Could you post that data again with column names and indicate where one column ends and the next starts please? Right now I don’t really see what’s what …