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
- 5189 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / siri
select * from table name where price=20
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Where are the settings stored for each instance in oracle?
How to do a full database export?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is the usage of save points in oracle database?
What are the different editions of oracle?
How to set up autotrace for a user account?
What are the differences between date and timestamp in oracle?
Can we write dml statement in function in oracle?
How a tablespace is related to data files?
Why does oracle 9i treat an empty string as null?
How to create an initialization parameter file?
What is a read only transaction in oracle?
How to define an oracle sub procedure?
How to get the Installed Oracle Version Information ?
