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
5674 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 maximum limit on the number of columns in a table?

1044

Is a rollback possible to any savepoint?

1039

What happens if you use a wrong connect identifier?

1010

what are steps for interface? where is exchange rate defined in which table?

2090

What is MTTR advisor in Oracle?

1058

What are the four Oracle system processes that must always be up and running for the database to be useable?

974

How can I get column names from a table in oracle?

1009

How to use null as conditions in oracle?

1035

How to delete all rows a table in oracle?

1031

What is meant by joins?

1032

What are the uses of a database trigger?

956

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2283

What is an Oracle Instance?

1092

How to name query output columns in oracle?

1150

What is difference between sid and service name in oracle?

923