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
5804 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 do I uninstall oracle client from windows?

1010

What is a oracle database?

1055

Which are the five query types available in oracle?

949

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

Which is better Oracle or MS SQL? Why?

4943

What is the simplest tool to run commands on oracle servers?

1009

How to connect the oracle server as sysdba?

1077

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1846

What is a table index in oracle?

1131

In the oracle version 9.3.0.5.0, what does each number shows?

1301

What is the exact use of Collections?

2143

How to join two tables in a single query using oracle?

997

How to login to the server without an instance?

1162

How to bring a tablespace online?

1079

Why do you use stored procedures and state some of its disadvantages?

1028