Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 5824 Views
- TCS, I also Faced
- E-Mail Answers
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 the relationship among Database, Tablespace and Data file?
when do u go for hash partitioning?
What are the differences between lov and list item?
What do you mean by cdb and pdb in oracle 12c?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
What is the function of Optimizer ?
How to get maxsal , minsal, ename department wise in single query
How different is ms access and oracle?
What happens if recursive calls get out of control?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
What are the major difference between truncate and delete?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Oracle General 
