select sum(sales) sales_count,sum(sales_amount) t_sales

Source is Sales Table:
Sno Prod Sales Sales_Amount
1 A 10 2000
2 A 20 1000
3 C 10 3000
4 D 30 4000
5 A 20 1000

Target :
Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A)
90 11000 50 4000

In single query, pls tell me.

Question Posted / ravi

5 Answers
8555 Views
CGI, I also Faced
E-Mail Answers

Answer Posted / ravi

select sum(sales) sales_count,sum(sales_amount) t_sales_amount
,(select sum(sales_count) sales_count(A),sum(sales_amount)
t_sales_amt(A) from sales_table group by prod) from sales_table;

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which one is better subquery or joins?

1114

Can we create table inside stored procedure?

1009

How many clustered indexes can you have?

1037

What are the basic sql commands?

1138

What are the benefits of stored procedures?

1126

How do you write an inner join query?

985

what is the use of friend function? : Sql dba

1057

What is meaning of <> in sql?

1127

what is 'mysqlcheck'? : Sql dba

1063

What is package in pl sql with an examples?

1083

Why use stored procedures?

1139

Can we commit inside a trigger?

1047

What is sql dialect?

1172

What is rank () in sql?

997

What is the clause we need to add in function body to return variable?

1050