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

How to select some rows from a table in oracle?

1002

Explain the use of rows option in exp command.

1020

11. Display the client number and name and the client number and name of the person who referred that client.

2270

How to create an oracle database?

975

Is oracle a relational database?

870

What privilege is needed for a user to connect to oracle server?

937

What is the difference between truncate & delete command?

1121

Explain a data segment?

1010

What is concurrency in oracle?

945

How to drop an index?

904

How to drop an existing table in oracle?

1011

How to loop through a cursor variable?

1010

What is redo log?

1003

What is the sid in oracle?

892

why dont we assign not null constraint as table level constraint.

2682