smoothing

[Olivier]

Hello
My problem:
I have datas like

A B
A001 2007-10-01
A003 2007-10-05
A004 2007-10-04
A008 2007-10-06

I want to make a query ordered by column A skipping value where column B
is lower than previous (eg A004):

A B
A001 2007-10-01
A003 2007-10-05
A008 2007-10-06

If someone can help, thanks.

 

[Allen Browne]

Use a subquery in the WHERE clause to skip those records where the date is
lower.

If subqueries are new, here's an introduction:
http://allenbrowne.com/subquery-01.html