Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 10 Answers
- 14706 Views
- Fidelity, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Answer / pratap
A)Select product, Max (cost) from product where cost <
(select max (cost) from product);
| Is This Answer Correct ? | 7 Yes | 13 No |
What is db2? Explain.
how do u update the faltfile into db2 table ?
What is db2 connect?
How can you find out the # of rows updated after an update statement?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What is a data page?
How to resolve -818 sql code in DB2?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
In terms of DB2 indexing, what is the root page?
Explain the contention situations caused by locks?
What is Call attach facility? How does it work?
COBOL 
