Selecting maximum from a list

[hpl2001]

Hi:

In the Where section of a Select statement I want to use a statement that tests if a date is less than the maximum of a group of dates...so in plain language it would be:

Where
DateA is less than the maximum of (DateB, DateC, DateD)

Can this be done?

TIA

Holly

 

[sem]

greatest(DateB, DateC, DateD)

Regards, Dima

http://seminihin.narod.ru

 

[Andrzejek]

1.
[tt][blue]SELECT MAX(DateField) From MyTable[/blue][/tt]

2.
[tt]SELECT WhatEver From SomeTable
Where
DateA < ([blue]SELECT MAX(DateField) From MyTable[/blue])[/tt]

Have fun.

---- Andy