Archives of the TeradataForum

Message Posted: Fri, 24 Aug 2001 @ 10:22:49 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

if you want only to select date from one field and maximum and minimum times for that date from another column use following SQL:

sel date_column, min(time_column), max (time_column)
from data
group by 1;

	<Prev	Next>		<<First	<Prev	Next>	Last>>