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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Explain oracle 12c new features for developers?
What is Java Pool in Oracle?
What are the ansi data types supported in oracle?
What is Segment Advisor in Oracle?
How to use subqueries with the exists operator in oracle?
Differentiate between post-database commit and post-form commit?
What is a cursor and what are the steps need to be taken?
How to run the anonymous block again?
What is an Index ?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to bring a tablespace online?
Will you be able to store pictures in the database?explain.