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

Is there any easy way to convert VB6 programs to VB.Net?

3 Answers  

what r the properties should be given to set method?

2 Answers   PSI Data Systems,

Compare c# and visual basic.net?

0 Answers  

hey friends, Firstly I pick the records from the database into the DataGridView, Then I want that If I made any changes to the records in the GridView & Click on Update Button, Changes are Reflected into the main Database .Plz do reply back

4 Answers  

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

0 Answers  

Explain how to store decimal data in .net?

0 Answers  

What is the difference between a "jagged array" and multidimensional array" ?can anyone show me it practically ?

0 Answers  

What is the difference between Dataset and Recordset?

7 Answers   IG, Silicon,

how can we assigns items on listbox so that it will show rowwise please write the code for it.

3 Answers  

Explain the difference between vb 6 and vb.net?

0 Answers  

how to create views in sql with syntax and example

5 Answers  

I have an opening for "APRIMO" Developer in Mumbai Location

1 Answers