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
5815 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 write a query with an inner join in oracle?

1044

Briefly explain what is literal? Give an example where it can be used?

1046

How to get a list of all background sessions in the database?

993

What is the quickest way to fetch the data from a table?

1059

What is the difference between postgresql and oracle?

1055

What is an oracle table?

993

What is enter substitution variable in oracle?

1058

Please explain compound trigger in oracle?

1066

Please explain joins in oracle?

1066

What is the difference between PFILE and SPFILE in Oracle?

1065

How to export data with a field delimiter?

1045

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2002

What is ADDM Advisor in Oracle?

1184

How do I spool in oracle?

1015

How to use attributes of the implicit cursor in oracle?

1012