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

What is visual basic.net culture?

0 Answers  

What is pre-jit?

0 Answers  

if user enters 1 or 2 or any other number in digit format in next textbox it should show the answer in word reading like if enters 12 answer should be twelve

4 Answers  

What is a preprocessor directive in vb.net?

0 Answers  

how to get dynamic control array position or its index position?

0 Answers   CMC,

Why is the xml infoset specification different from the xml dom?

0 Answers  

Explain about globalization?

0 Answers  

what is vb.net?

10 Answers  

How do you do multithreading application in VB ?

4 Answers   Satyam,

how to create crystal reports in asp.net & vb.net with syntax

2 Answers  

What do you understand by vb.net?

0 Answers  

What does VS.NET contains ?

3 Answers   Infosys,