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
5637 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

What is key preserved table?

961

Is postgres faster than oracle?

972

What is not equal to in oracle?

953

Is a rollback possible to any savepoint?

1002

How oracle handles dead locks?

1021

WHAT IS ecc 6.0

2103

What is a database table in oracle?

954

What is the relation of a user account and a schema?

1064

How to install oracle database 10g xe?

967

What is clustered table in Oracle?

1108

What is a cursor variable?

1047

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

978

How can I introduce multiple conditions in like operator?

926

Is oracle an open source?

1021

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2147