Is it possible to use Aggregate function in a Select statment without using Group By clause?
Posted by karuta em novembro 22, 2013
You can use Select AGG() OVER() in TSQL
SELECT *, SUM(Value) OVER() FROM Table
There are other options for Over such as Partition By if you want to group:
SELECT *, SUM(Value) OVER(PARTITION By ParentId) FROM Table