T-SQL How to get SUM() from a subquery

Question

Hi, I need fast answer (I can't check that code right now):

is that query works ? I need to get the total sum of a column values from the subquery, something like that:

  select sum(select time from table) as sometimes group by sometimes

Answer 1

That isn't a subquery. You only have 1 from...

Answer 2

That doesnot work, try this

select sum(time) as sumtime from table

Answer 3

I doesn't appear that you even NEED a subquery, as this will work:

SELECT SUM(Time) as TimeSum
FROM Table