select duplicates

[fmt]

Hello,
How do I get max tag1 for given distict dates?

DATE TAG1
2005-10-08 06:15:00.000 0
2005-10-08 06:15:00.000 1
2005-10-08 06:30:00.000 0
2005-10-08 06:30:00.000 1
2005-10-08 06:45:00.000 1
2005-10-08 07:00:00.000 0
2005-10-08 07:15:00.000 0

I need to see something like

DATE TAG1
2005-10-08 06:15:00.000 1
2005-10-08 06:30:00.000 1
2005-10-08 06:45:00.000 1
2005-10-08 07:00:00.000 0
2005-10-08 07:15:00.000 0

Thanks

 

[cLFlaVA]

something like this should do the trick:

  select date
       , max(tag1)
    from mytable
group by date

*cLFlaVA
----------------------------
[tt]I already made like infinity of those at scout camp...[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[fmt]

Thanks cLFlaVA !!!
but I have one more field to be selected. If I select that field the results are not same.
Date Tag1 Tag2
2005-10-08 09:00:00.000 0 0
2005-10-08 09:00:00.000 1 1
2005-10-08 09:15:00.000 0 0
2005-10-08 09:15:00.000 1 0
2005-10-08 09:15:00.000 1 1
2005-10-08 09:30:00.000 0 0
2005-10-08 09:30:00.000 1 0
2005-10-08 09:30:00.000 1 1
2005-10-08 09:45:00.000 0 0

I need something like
Date Tag1 Tag2
2005-10-08 09:00:00.000 1 1
2005-10-08 09:15:00.000 1 1
2005-10-08 09:30:00.000 1 1
2005-10-08 09:45:00.000 0 0

 

[jbenson001]

Try:

select A.*
from myTable A
inner join
(    select [Date], Max(Tag1) as maxTag1
    from myTable
    group by [Date]
) B on A.[date]=B.[date] and A.Tag1 = B.maxTag1