CREATE CURSOR C_Blank (dateb D, n_blank I, condition I)
INSERT INTO C_Blank (dateb, n_blank, condition) ;
  VALUES (DATE( 2005 , 10 , 10 ),  123456 ,  3 )
INSERT INTO C_Blank (dateb, n_blank, condition) ;
  VALUES (DATE( 2004 , 11 , 11 ),  123456 ,  2 )
INSERT INTO C_Blank (dateb, n_blank, condition) ;
  VALUES (DATE( 2005 ,  5 , 10 ),  123456 ,  6 )
INSERT INTO C_Blank (dateb, n_blank, condition) ;
  VALUES (DATE( 2006 , 11 , 11 ),  444444 ,  7 )

SELECT B.dateb, B.n_blank, B.condition ;
  FROM C_Blank B INNER JOIN ;
    (SELECT n_blank, MAX(dateb) AS dateb FROM C_Blank GROUP BY n_blank) B1 ;
    ON B.n_blank = B1.n_blank AND B.dateb = B1.dateb