1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

I have a table(product),It contain fields(productname,cost).
I want to retrieve the product name ,which cost is second
maximum in the table?

Question Posted / srinvas

Answers were Sorted based on User's Feedback



I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,w..

Answer / venkat ramana

SELECT PRODUCTNAME
FROM PRODUCT
WHERE COST < (SELECT MAX(COST)FROM PRODUCT)
ORDER BY COST DESC
FETCH FIRST 1 ROW ONLY ;

HOPE THE ABOVE QUERY WILL PROVIDE YOU THE DESIRED RESULT.

Is This Answer Correct ?    14 Yes 2 No

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,w..

Answer / rajasekaran

with e as (select product_name,cost,rank() over(order by
cost desc) as rk from product) select * from e where rk=2;

Is This Answer Correct ?    3 Yes 0 No

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,w..

Answer / viki

SELECT PRODUCTNAME FROM PRODUCT WHERE COST <> max(COST)

AND PRODUCTNAME=

(SELECT PRODUCTNAME FROM PRODUCT WHERE COST =
(SELECT COST FROM PRODUCT
ORDER BY COST DESC
FETCH FIRST TWO ROWS ONLY))

Is This Answer Correct ?    0 Yes 0 No

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,w..

Answer / dinesh m

A)
select productname from product
where cost=(Select max(cost) from product where cost not in
(select max (cost) from product) );

Is This Answer Correct ?    0 Yes 0 No

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,w..

Answer / pc

select productname from product where cost=(select max(cost) from product where cost<> (select max(cost) from product));

Is This Answer Correct ?    0 Yes 0 No

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,w..

Answer / vineeth varghese

(Select product from product where cost = (Select Max (cost) from product where cost not = (select max (cost) from product)))

Is This Answer Correct ?    0 Yes 0 No

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,w..

Answer / siri

select productname from product p where 2=(select count(*) from product q where p.cost<=q.cost)

Is This Answer Correct ?    0 Yes 1 No

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,w..

Answer / mr. cooooool

Hi............

SELECT PRODUCTNAME FROM PRODUCT WHERE COST = (SELECT MAX(COST)
FROM PRODUCT WHERE COST > (SELECT MAX(COST) FROM PRODUCT));

THANKS
REGARDS
RAVINDRA BISHT

Is This Answer Correct ?    13 Yes 15 No

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,w..

Answer / ananth

We can also use correlated subquery for this..

Select product from product a where 1 =
(select count(*) from product b where a.cost < b.cost);

Is This Answer Correct ?    0 Yes 3 No

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,w..

Answer / pratap

A)Select product, Max (cost) from product where cost <
(select max (cost) from product);

Is This Answer Correct ?    7 Yes 13 No

Post New Answer

More DB2 Interview Questions

What is the maximum number of columns in a db2 table?

0 Answers   IBM,

Explain the use of the WHERE clause.

2 Answers   IBM,

Explain the use of the WHERE clause?

1 Answers  

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

How to rename a table in DB2 ?

0 Answers   MCN Solutions,




What is image copy in db2?

0 Answers  

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

How do I create a view in db2?

0 Answers  

How do I delete a table in database?

0 Answers  

How are write I/Os from the buffer pool executed?

1 Answers  

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

What are the prerogatives?

0 Answers  

For more DB2 Interview Questions Click Here
Categories