SQL Server - SUM (column) * QtyColumn

Question

Is it possible to get the total without returning it in multiple rows (Group BY)?

Example:

Data:

ID Amount Quantity 1 50 1 2 50 2 

 select sum(Amount) * Quantity, SUM(Quantity) as totalQuantity from tbl 

I want the results to be in 1 line:

 total totalQuantity 150 3 

Answer 1

Here you go

 SELECT SUM(Amount*Quantity) as total, SUM(Quantity) as totalQuantity 

Answer 2

 select sum(Amount * Quantity) as total, sum(Quantity) as totalQuantity from your_table