SELECT PRODUCTID, PRICE, COUNT(*) AS CNT FROM PRODUCT GROUP BY PRODUCTID,P

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.

Question Posted / pkunde

3 Answers
5745 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / pkunde

SELECT PRODUCTID, PRICE, COUNT(*) AS CNT FROM PRODUCT
GROUP BY PRODUCTID,PRICE HAVING CNT = 1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between sharding and partitioning?

968

What is the difference between formal parameters and actual parameters?

1065

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2340

How to sort the query output in oracle?

1009

How to start a new transaction in oracle?

1067

How to check the server version in oracle?

1081

How to write an inner join with the where clause in oracle?

1033

What do you mean by a tablespace?

1029

Explain integrity constraints?

1091

Explain an integrity constrains?

1127

How to retrieve data from an explicit cursor?

1040

How to open a cursor variable?

1016

How to invoke the data pump import utility?

1143

How to update values on multiple rows in oracle?

1022

What is oracle instant client?

1006