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
5917 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 does sharding mean?

what is the uses of cusor

3 Answers Perot Systems,

Explain the use of online redo log files in oracle.

How to execute the package in oracle?

What is the relationship among database, tablespace and data file?

What is cursor

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

0 Answers Wipro,

What is rowid and rownum in oracle?

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

What is meant by joins? List out the types of joins.

What is a schema in oracle?

What is a data dictionary and how can it be created?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1803)
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)