sql satement for 2nd maximum value
Answers were Sorted based on User's Feedback
Answer / archana chavan
select top 1 * from author where phone < (select max(phone)
from author) order by phone desc
Is This Answer Correct ? | 18 Yes | 4 No |
Answer / murli d
author is Table name
ID is column name
select top 1 * from author where ID < (select max(ID)
from author) order by ID desc
Is This Answer Correct ? | 16 Yes | 3 No |
Answer / cherran
select top 1 sal from
( select top 2 sal from test order by sal desc ) as kk order
by sal
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / avnish
create table emp with row empsal having the datatype float
and insert some salary
now to get the second max salary
write the sql statement
select max(empsal) from emp where empsal<(select max(empsal)
from emp)
its asubquery
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / sanjeev singla
Hey guys use this query ,i used it so many time ,it will be
useful to you..try this one...
SELECT MAX(Salary) AS Expr1
FROM Employees
WHERE (Salary <
(SELECT MAX(Salary)
FROM Employees))
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ramavtar rajput
select Amount from T2 where Amount = ( select max(Amount)
from T2 where Amount < ( select max(Amount) from T2 ))
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / kaushal gajjar
select top 1 UnitsInStock
from products
where UnitsInStock in (select top 2 UnitsInStock from
products order by UnitsInStock desc)
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / suresh
department as table name,sfee as column name
SELECT TOP (1) sfee
FROM DEPARTMENT
WHERE (SFEE IN
(SELECT TOP (2) SFEE
FROM DEPARTMENT AS
DEPARTMENT_1
ORDER BY SFEE DESC))
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / jacob
1)Select Max(Total) from mark
2)select top 1 total from
( select top 2 total from mark order by total desc ) as
result order
by Total
Is This Answer Correct ? | 0 Yes | 0 No |
What are the difference between dispose(), close(), exit(), end()? When do we use them?
How to send xml file on server using http protocol?
Describe about visual basic.net?
Is VB.NET object oriented? What are the inheritances does VB.NET support ?
13 Answers Digital GlobalSoft, Global Infotech, Infosys,
Can you please explain the difference between value and reference types?
what are the advantages and diadvantages of active reports over crystal reports ?
how to connect crystal report with vb.net ?
What would you do to remove microsoft visual basic name space?
how to deploy vb.net with key and evaluation time? any one can help me?
Why is the xml infoset specification different from the xml dom?
What are the shared variables?
Explain about jagged arrarys ?