SELECT T1.SALES_COUNT, T1.T_SALES_AMT, T2.SALES_COUNT_A, T2.T

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 / welcomeashwin

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

Answer Posted / welcomeashwin

SELECT
T1.SALES_COUNT, T1.T_SALES_AMT,
T2.SALES_COUNT_A, T2.T_SALES_AMT_A
FROM
(SELECT SUM(SALES) SALES_COUNT,
SUM(SALES_AMOUNT) T_SALES_AMT
FROM SALES)T1,
(SELECT SUM(SALES) SALES_COUNT_A,
SUM(SALES_AMOUNT) T_SALES_AMT_A
FROM SALES
WHERE PROD='A' GROUP BY PROD)T2

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does postgresql compare to mysql?

986

How do I add a database to sql?

1062

How do I view a table in sql?

947

Why do we need unique key in a table?

882

what is a database? : Sql dba

1097

Can a composite key be null?

909

How is data stored on a disk?

961

What is exception? What are the types of exceptions?

1030

What is the difference between rename and alias?

1267

What is the difference between an inner join and an outer join?

967

Is primary key always clustered index?

945

What does 0 mean in sql?

910

what is an index? : Sql dba

930

Can we use distinct and group by together?

990

How do I edit a stored procedure?

946