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?

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

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  


How many clustering indexes can be defined for a table?

2 Answers  


how 2 resolve the -311 sqlcode

1 Answers  


Why do chiropractors use drop table?

0 Answers  


Where can you declare a cursor in a cobol-db2 program?

0 Answers  






What is db2 isolation?

2 Answers  


Name some fields from SQLCA.

2 Answers  


What is filter factor?

2 Answers  


What is db2?

0 Answers  


What does DSNDB07 database do?

2 Answers  


In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  


What is buffer pool in the db2 database?

0 Answers  


Categories