Re: SQL question on date manipulation

Subject:	Re: SQL question on date manipulation
From:	"Cook, Dwight E" <DWIGHT.E.COOK AT SAIC DOT COM>
Date:	Wed, 8 May 2002 10:55:20 -0700

select filespace_name,class_name,archive_date from archives where
node_name='blah' and archive_date=(select max(archive_date) from archives
where node_name='blah')

then do the same with MIN function...

<Prev in Thread]	Current Thread	[Next in Thread>
SQL question on date manipulation, Jolliff, Dale Re: SQL question on date manipulation, Williams, Tim P {PBSG} Re: SQL question on date manipulation, Jolliff, Dale Re: SQL question on date manipulation, William F. Colwell Re: SQL question on date manipulation, Cook, Dwight E <= Re: SQL question on date manipulation, Cook, Dwight E Re: SQL question on date manipulation, Alex Paschal Re: SQL question on date manipulation, Jolliff, Dale Re: SQL question on date manipulation, Jolliff, Dale Re: SQL question on date manipulation, Thomas A. La Porte Re: SQL question on date manipulation, Alex Paschal Re: SQL question on date manipulation, Jolliff, Dale