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
5636 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 port in oracle? how is it related to database application.

What are transaction isolation levels supported by oracle?

What is Index Cluster ?

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

How to add a new column to an existing table with a default value?

How to get execution path reports on query statements?

Will you be able to store pictures in the database?

How to define Data Block size ?

What is a system tablespace and when it is created?

what is the difference between sql& oracle?

11 Answers Oracle,

How do I know if oracle is installed on windows?

how to get count of tables in particular database in Oracle?

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)