Getting Duplicates

[pradchal1]

In a situation like the following:

A 05-05-2005 Blue
A 05-05-2005 Red
A 05-05-2005 Red
A 04-04-2004 Red
B 05-05-2005 Red
B 05-05-2005 Red
B 04-04-2004 Yello

How do I get the following table:

A 05-05-2005 Red
A 05-05-2005 Red
A 05-05-2005 Blue
B 05-05-2005 Red
B 05-05-2005 Red

Note: Basically I am trying to get the highest date for each color. If it is present more than once, I want both the instances.

Thanks.

 

[DrSql]

Just group by those fields.

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[swampBoogie]

select * 
 from t as q
where dateColumn in
  (select max(dateColumn)
    from t
    where t.colour = q.colour)

 

[DrSql]

select col1,col2,col3 from table
group by col1,col2,col3

Should give you what you are looking in your case

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[pradchal1]

Tips from SwampBoogie worked. Dr.sql's logic does not work here.
Thanks to both of you.