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 |
what are bitmap indexes? How does they work?
What is a Schema ?
How to convert dates to characters in oracle?
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
What to do if dba lost the system password?
Why do we use coalesce function in oracle?
How to speed up webrick?
Explain the difference between a procedure and a function?
How data locks are respected in oracle?
What is save point in oracle database?
What is Public Database Link ?
How to create an initialization parameter file?