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

Query to retrieve record for a many to many relationship ?

2502

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3187

various types of hints and their usage

2672

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2605

Can we create database in oracle using command line ?

1066

What is save point in oracle database?

1284

What do you understand by database schema and what does it hold?

1223

defination of bitmap index

2098

What is a oracle database?

1038

How to drop an existing table in oracle?

1050

What is the difference between post-database commit and post-form commit?

1169

What is a user account in oracle?

1108

What is instant client oracle?

1012

What is the minimum client footprint required to connect c# to an oracle database?

1077

please explain.. DB architecture ...

2002