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

Explain the use of full option in exp command.

1116

Explain the use of inctype option in exp command.

1034

How can Oracle users be audited?

1115

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3200

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2030

Why do we use coalesce function in oracle?

1119

what is the difference between restoring and recovering?

1011

What is the difference between postgresql and oracle?

1048

How to synchronize 2 schema's objects?

2181

How can we find out the current date and time in oracle?

1088

How to use "while" statements in oracle?

1326

Can we call procedure inside function in oracle?

1093

What is an oracle tablespace?

1043

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

Explain the use of owner option in exp command.

1043