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

How do you eliminate duplicate values in db2?

1 Answers  

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

what is the difference between where clause and having clause

2 Answers   IBM,

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

How can you split a table in to exactly half?

7 Answers   HSBC,

What is the difference between Primary key and unique index?

6 Answers  

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

In terms of DB2 indexing, what is the root page?

1 Answers  

What is reorg?

1 Answers  

What is an alias?

3 Answers  

What is the difference between base table and view?

7 Answers  

For more DB2 Interview Questions Click Here
Categories