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
5643 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 an oracle and why it is used?

1081

How to write date and time literals in oracle?

949

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1619

What is hash cluster in oracle?

1091

Explain a segment?

1026

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2309

How do you bind variables in oracle?

932

How to connect to oracle using service name instead of sid?

964

How to update a table row with a record?

963

What is save point in oracle database?

1243

How to create an initialization parameter file?

987

How would you best determine why your MVIEW couldnt FAST REFRESH?

1839

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

997

What is ASM (Automatic Storage Management) in Oracle?

1126

How do I uninstall oracle client from windows?

962