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
- 5670 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 |
Can objects of the same schema reside in different tablespace?
difference between truncate and delete ,drop?
Define the terms primary key foreign key and also the difference between primary and the unique key
What are steps required to ENTER DATA INTO DWH?
how to get last monday of a month?
List out the components of logical database structure of oracle database.
What is the difference between normal and corelated subqueries?
what are the things that you consider while creating indexes on partitioning tables?
Can a formula column be obtained through a select statement ?
How to run create database statement?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
State any two functions of oracle?
Oracle General 
