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
5916 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

Is rowid unique in oracle?

1048

What is a cognitive schema?

1035

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2602

What is a table index in oracle?

1187

How does Oracle guarantee data integrity of data changes?

2458

what is the scripts in data base?

2222

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2038

if you ctreate table identity

2430

what is a Nested Loop join?

2175

Explain oracle instance.

1234

What are the ansi data types supported in oracle?

992

Explain the use of analyse option in exp command.

1199

What is the difference between a hot backup and a cold backup in oracle?

1079

What is primefaces used for?

1098

What are the different editions of oracle?

1180