SELECT PRODUCT_ID, PRICE FROM PRODUCTS GROUP BY PRODUCT

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 / venkataselvaraj@gmail.com

3 Answers
5810 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / venkataselvaraj@gmail.com

SELECT PRODUCT_ID, PRICE FROM PRODUCTS
GROUP BY PRODUCT_ID, PRICE
HAVING COUNT(*) = 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 call a sub procedure?

1098

Is a rollback possible to any savepoint?

1098

11. Display the client number and name and the client number and name of the person who referred that client.

2340

what's query optimization and without use of IN AND Exist can we get another way data from query

2144

How do I reset a sequence in oracle?

1103

What is a subquery in oracle?

1111

Does oracle database need java?

1013

Is oracle a language?

952

How to revoke create session privilege from a user in oracle?

1018

Can a parameter be passed to a cursor?

1127

What are the execution control statements in oracle?

1097

What are dml statements in oracle?

1095

What are the different types of failures that occur in Oracle database?

1068

How to check your oracle database 10g xe installation?

989

Explain the use of grant option in imp command.

1030