Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


To find second largest salary in Employee table

Answers were Sorted based on User's Feedback



To find second largest salary in Employee table..

Answer / anu

Select max(Sal) from emp
Where
Sal
<
(Select max(Sal) from emp);

Is This Answer Correct ?    0 Yes 0 No

To find second largest salary in Employee table..

Answer / sujith

select empname,salary from(
select empname,salary, rank() over( order by salary desc) ss from emp)
where ss=2;

Is This Answer Correct ?    3 Yes 4 No

To find second largest salary in Employee table..

Answer / ela tiku

Select Max(SAL) FROM emp WHERE sal<(SELECT MAX(SAL) FROM
emp)


<<<assuming sal is the column name and emp is the table
name>>>

Is This Answer Correct ?    0 Yes 1 No

To find second largest salary in Employee table..

Answer / kuduba.r

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

Is This Answer Correct ?    0 Yes 1 No

To find second largest salary in Employee table..

Answer / anjum

SELECT MAX(SALARY)FROM EMP WHERE SALARY(SELECT MAX(SALARY)
FROM EMP)

Is This Answer Correct ?    0 Yes 1 No

To find second largest salary in Employee table..

Answer / murugesh

select * from (select row_number over( order by salary
desc) as salcount,empid,salary from employee) emp
where emp.salcount = 2

Is This Answer Correct ?    1 Yes 2 No

To find second largest salary in Employee table..

Answer / chitharthan

select max(salary)-1 from employeetable

Is This Answer Correct ?    0 Yes 10 No

Post New Answer

More SQL Server Interview Questions

How do we rollback the table data in SQL Server

3 Answers  


Is it possible to have clustered index on separate drive from original table location?

0 Answers  


in how many ways we can use count()

2 Answers  


What are different types of schemas?

0 Answers  


if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,


What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,


Can you insert NULL in unique column?

0 Answers   MCN Solutions,


How to view existing indexes on an given table using sp_help?

0 Answers  


What is the recovery model?

0 Answers  


What is serializable?

0 Answers  


two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  


Are null values the same as that of zero or a blank space?

0 Answers  


Categories