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

Explain the difference between .dll extension and .exe extension files?

0 Answers  

Why do we use byref keyword in vb.net?

0 Answers  

Can you please explain the difference between int and int32?

0 Answers  

what is diffrence constructor and destructor in vb

0 Answers   MCN Solutions,

What is the size of .net object?

0 Answers  

What are the advantages of an assembly?

0 Answers  

hi dear ! thank u for replying to my question regarding adding third party software in vb.net .My next question is that i haven created Data base in SQL server 2000 for Library and has connected that with VB and VB.net separately but it only works on single computer and when i takes my software to another computer on same Network it does not work . Can any body help me what i do to solve. Regards!

1 Answers  

What is the use of errorprovider control?

0 Answers  

What are the advantages of migrating to vb.net?

0 Answers  

What is difference between inline and code behind?

0 Answers  

Which control is an example of an object in vb net?

0 Answers  

i have attended interview for cognizant ( 3 +,on .net ) on 19-06-2010 till now i have not given the status ..am confused... does any one faced same situation ...could please tell what would be happened

1 Answers