How can apply min(date) and max(date)

Hi

Looking for this kind of query in view.

Query : Select min(dt),max(dt2) from dt_tb group by name

-Nigam