I have a table like this Table Name:Products Productid Price 1 10

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 / rameshrr25

3 Answers
5741 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 ..

Answer / siri

select * from table name where price=20

Is This Answer Correct ?

3 Yes

0 No

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 ..

Answer / pkunde

SELECT PRODUCTID, PRICE, COUNT(*) AS CNT FROM PRODUCT
GROUP BY PRODUCTID,PRICE HAVING CNT = 1

Is This Answer Correct ?

0 Yes

0 No

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 ..

Answer / venkataselvaraj@gmail.com

SELECT PRODUCT_ID, PRICE FROM PRODUCTS
GROUP BY PRODUCT_ID, PRICE
HAVING COUNT(*) = 1;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

What is pragma autonomous transaction in oracle?

what is meant by magic query

How to create a new oracle data file?

What is a subquery in oracle?

what is the syntax of SELECT command?

What are various constraints used in SQL?

1 Answers Polaris,

how to see the data (in unix) using dataset in datastage?

1 Answers iGate,

What is a sub query? What are its various types?

What is the use of aggregate functions in oracle?

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

Explain a synonym?

Can we connect to ORACLE db using Windows Authentication?

0 Answers MCN Solutions,

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)