by filtering with diferent

Is it possible to filter duplicates codes by filtering with diferent
dates???

I have a table from where i load into my tables, that table has not
got PK on cod1. When i try to load into my table1 found that there is
a lot of duplicates.

So i am trying to group then as:

if date1 is not null then return date1 as data1
elseif data2 is not null then return data2 as data2
elseif data3 is not null then return data3 as data3

select distinct cod1, max (data1)
from table
where date1 is not null
group by grouping sets (cod1 , date1 )

this query returns some blanks that i dont know how to manage.

Anyone has any idea ??

Thanks in advance ..
A.

.

Relevant Pages

  • Across the Megaverse...
    ... 'THE COSMIC LANDSCAPE,' BY LEONARD SUSSKIND ... Physicists are not like ordinary people, and string theorists are not ... extraordinary fact that the universe appears to be uncannily, nay, ... latest ideas in physics, God "had no freedom at all." ...
    (sci.space.history)
  • Across the Megaverse... (NEW YORK TIMES)
    ... 'THE COSMIC LANDSCAPE,' BY LEONARD SUSSKIND ... Physicists are not like ordinary people, and string theorists are not ... extraordinary fact that the universe appears to be uncannily, nay, ... latest ideas in physics, God "had no freedom at all." ...
    (sci.space.policy)
  • Re: Dr. Amanda Peet - String Theory
    ... All mass, ... Universe? ... I'm just a Ph.D scientist that took some physics classes way before ... do we just have to find the right string to get to Mars? ...
    (soc.retirement)
  • Re: Chez Watt: Entropy in crystalization: up or down?
    ... contains all the information in the whole universe over time? ... an infinite universe could be represented by a single infinite string. ... It then follows that the laws of physics, ... "All physical systems register and process information. ...
    (talk.origins)
  • Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
    ... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
    (alt.photography)