Answer / amruta dash

select max(salary) from tblname where salary not in (select
max(salary) from tblname);

Answer / vamsi krishna

For 2nd maximum salary
select Max(sal) from EMP a where 2=(select COUNT(distinct(sal)) from EMP b where a.SAL<=b.SAL);

Answer / rajkumar v

Select min(salary)FROM emp WHERE (salary IN (SELECT TOP 2
salary FROM emp ORDER BY salary DESC))

Answer / kavitha

select max(salary) from tablename where salary not in(select
max(salary) from tablename )

or


select max(salary) from tablename where salary <(select
max(salary) from tablename )

Answer / vishnu

Here we can find out 2nd highest salary in many ways,
according to the situation we can select anyone…
1st Type:
select min(esal) from emp where esal in (select top 2 esal
from emp order by esal desc)

2nd Type:
select max(esal) from emp where esal not in(select max(esal)
from emp)

3rd Type:
select max(esal) from emp where esal <(select max(esal) from
emp )

4th Type:
select Max(esal) from EMP a where 2=(select
COUNT(distinct(esal)) from EMP b where a.eSAL<=b.eSAL);

Answer / m.s.patil

select max(sal) from t1 where sal not in (27777);

27777 is max salary in table

Answer / sannnnnnnnnnn

select max(sal) from emp where sal<(select max(sal) from emp)

Answer / raja

select top1 salary from(select distinct top2 salary from
table name order by salary desc)a order by salary

Answer / moorthy t

select n,* from(select rownum n,* from (select * from table
where group by (sal) order by (sal) desc)) where n=2;

Answer / sandeep rana

select max(salary) from salary_table where salary in(select
top 2 salary from salary_table order by salary desc)

What is the difference between DATETIME2 and DATETIME?

1 Answers   Infosys,

Can you create a logon trigger in sql server 2005 express edition?

1 Answers  

What happens if an integer is too big for int date type?

1 Answers  

How many primary keys are possible in a table?

1 Answers  

What is data compression? : sql server database administration

1 Answers  

What is onf in normalization form?

1 Answers  

What are the requirements to use odbc connections in php scripts?

1 Answers  

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

can any one say how to update the following senario I have a table <srabank> in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <accountno> <31518746291> the balance is <4000> for the <accno> <31518746292> the balance is <14000> after transferring the balance the details will look as follows <accno><31518746291> <bal> <2000> <accno><31518746292> <bal> <16000> the above mentioned two statment will come under the final result.

3 Answers  

Do you know what is similarity and difference between truncate and delete in sql?

1 Answers  

Why should one not prefix user stored procedures with ‘sp_’?

1 Answers  

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1 Answers   TCS,