Colocar a Mínimo Geral na linha do registro

Question

Quando faço o seguinte select

SELECT 
       [DataEntrega]
      ,[DataEmissao]
      ,[Dias]
      ,min(Dias) as Minimo
  FROM [vw_RelEmissaoDocumentoTempo] where acessousuarioid = 32

aparece o seguinte resultado:

DataEntrega                           DataEmissao                          Dias        Minimo

2011-03-02 00:00:00.000      2014-05-01 00:00:00.000     1306       1306
2011-03-02 00:00:00.000      2014-05-01 00:00:00.000     1306       1306
2014-05-31 00:00:00.000      2014-06-02 00:00:00.000     140         140
2014-05-31 00:00:00.000      2014-06-02 00:00:00.000     140         140

Sendo que para calcular a Coluna Dias eu usei o datediff(dd,DataEntrega,DataEmissao).

Como eu faço para ficar assim

DataEntrega                          DataEmissao                          Dias        Minimo

2011-03-02 00:00:00.000      2014-05-01 00:00:00.000     1306       140
2011-03-02 00:00:00.000      2014-05-01 00:00:00.000     1306       140
2014-05-31 00:00:00.000      2014-06-02 00:00:00.000     140         140
2014-05-31 00:00:00.000      2014-06-02 00:00:00.000     140         140

Answer 1

Deleted

Answer 2

Deleted

Answer 3

E se for o máximo, o mínimo e a média? Tentei esse mas não deu certo

Select  
	DataEntrega, 
	DataEmissao,
	Dias = DATEDIFF(day,dataentrega,dataemissao),
	Maximo = MAX(DATEDIFF(day,dataentrega,dataemissao)),
	Minimo = Min (datediff(day,dataentrega,dataemissao)),
	Media = avg(datediff(day,dataentrega,dataemissao)) over()
from 
	vw_RelEmissaoDocumentoTempo 
where
	acessousuarioid = 32

Column 'vw_RelEmissaoDocumentoTempo.DataEntrega' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Answer 4

Deleted