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.
Answer Posted / siri
select * from table name where price=20
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can we force the database to use the user specified rollback segment?
Explain the difference between a procedure and a function?
What is the database name in oracle?
What are the parameters that we can pass through a stored procedure?
What is the string concatenation operator in oracle?
How to select some columns from a table in oracle?
How many anonymous blocks can be defined?
How to create additional tablespaces for an new database?
How do I find my oracle client driver version?
Can we connect to ORACLE db using Windows Authentication?
In which language oracle has been developed?
What is a tns service name?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What are the different types of failures that occur in Oracle database?
How to use "in" parameter properly?