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
- 5832 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 |
Whats the benefit of dbms_stats over analyze?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What is the difference between PFILE and SPFILE in Oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is the difference between a primary key & a unique key?
How many types of database triggers exist?
what is the bitmap index?
How to export data with a field delimiter?
How is it different from a normal table?
Find all employees in Dept “Marketing”.
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Difference between the “verify” and “feedback” command?
Oracle General 
