Answer / archana chavan

select top 1 * from author where phone < (select max(phone)
from author) order by phone desc

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

Answer / cherran

select top 1 sal from
( select top 2 sal from test order by sal desc ) as kk order
by sal

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

Answer / sonia

Rohan answer given by you was not working.....

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))

Answer / ramavtar rajput

select Amount from T2 where Amount = ( select max(Amount)
from T2 where Amount < ( select max(Amount) from T2 ))

Answer / kaushal gajjar

select top 1 UnitsInStock
from products
where UnitsInStock in (select top 2 UnitsInStock from
products order by UnitsInStock desc)

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))

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

List the types of generations in garbage collector?

0 Answers  

What would you do to remove microsoft visual basic name space?

0 Answers  

How do you define a read only property in a class module?

0 Answers  

Can you please explain the difference between c# and vb.net?

0 Answers  

hello friends.. when i deployment my project in the client machine that is successful but whenever i try to run my project using .exe file then it gives me error "<filename>.exe is not a valid win32 application." what i do somebody halp me pls

1 Answers  

What is the use of internal keyword?

0 Answers  

What is "Polymorphism" and what are Polymorphism in VB.Net?

2 Answers  

Allowed program to auto-correct the database when loading a presentation.

0 Answers   HCL,

What is the feature which is common to all .net languages?

0 Answers  

What is jagged array in vb.net?

0 Answers  

Explain the difference between int and int32?

0 Answers  

Explain the components of common language runtime.

0 Answers