select * from table name where price=20

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.

Question Posted / siri

3 Answers
5746 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

Please Help Members By Posting Answers For Below Questions

What is the simplest tool to run commands on oracle servers?

991

Can we create database in oracle using command line ?

1066

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2482

How to create a table index in oracle?

1119

Difference between varchar and varchar2 data types?

1158

Name the various constraints used in oracle?

1005

How to add another datafile to a tablespace?

1021

Explain an exception and its types?

1055

Is oracle a relational database?

904

How to select some columns from a table in oracle?

1065

What is Segment Advisor in Oracle?

1089

What operating systems are supported by oracle database 10g xe?

1022

Explain the use of grant option in exp command.

1043

Please explain oracle left join with an example?

1024

What is an Oracle index?

1639