SQL选择具有max和min日期的行

I am trying to get 2 rows from a table at one shot. The one with the minimum datetime (today - 7) of last week and the one which is the latest (today).I am trying to get 2 rows from a table at one s