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
5923 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

How to convert characters to dates in oracle?

1152

Is it possible to insert comments into sql statements return in the data model editor ?

2638

Is there any function in oracle similar like group_concat of mysql?

1112

What is the data type of dual table?

1069

What is a data lock in oracle?

1182

What is the disadvantage of User defind function?

2347

Give the various exception types.

1040

Name the various constraints used in oracle?

1082

How can you use check constraints for self referential integrity?

1019

How to define an external table with a text file?

1129

Is java required for oracle client?

1049

How view is different from a table?

1091

How do we display rows from the table without duplicates?

1019

How do I manually create a database in oracle?

1073

What is oracle data type?

1013