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
5918 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 open database communication (odbc) in oracle?

1053

How to start an oracle instance?

1076

How to write text literals in oracle?

1120

How to do a full database export?

1153

What privilege is needed for a user to query tables in another schema?

1034

How can I combine multiple rows into a comma-delimited list in oracle?

1119

How to write a query with a right outer join in oracle?

1224

What is the difference between 10g OEM and 11g OEM?

1017

What are the different windows events activated at runtime ?

2945

How to speed up webrick?

1126

What is transaction control statement and how many types of transaction control statement in Oracle?

1237

What are operators in oracle?

1103

How do we create privileges in oracle?

1103

How to run the anonymous block again?

1176

What is a snapshot in oracle database?

1073