Interview Questions Answers in Oracle General

selvaraj v

{ City } coimbatore
< Country > india
* Profession * sr.it consultant
User No # 115189

Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0

Questions / { selvaraj v }

Questions Answers Category Views Company eMail

Answers / { selvaraj v }

Question { TCS, 5638 }

I have a table like this
Table Name:Products
Productid Price
1 10
1 10
2 20
3 30
3 30

But i want to output like this.
productid price
2 20.

please replay me.

Answer

SELECT PRODUCT_ID, PRICE FROM PRODUCTS
GROUP BY PRODUCT_ID, PRICE
HAVING COUNT(*) = 1;

Is This Answer Correct ?

0 Yes

0 No