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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Find 2nd Highest salery in emp table

Select* from emp where &n=
select * count from emp where (salery >=emp.salery)


Enter n value 2


These query is correct or not. Tell me any other methods.

Question Posted / sujatha_k

Answers were Sorted based on User's Feedback



Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp whe..

Answer / asimananda

SELECT MAX(SAL) FROM EMP WHERE SAL < ( SELECT MAX(SAL) FROM
EMP )

Is This Answer Correct ?    7 Yes 2 No

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp whe..

Answer / kb

select top 1 * from emp
where sal < (select max(sal)from emp)
order by sal desc

Is This Answer Correct ?    3 Yes 0 No

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp whe..

Answer / lince

select top 1 * from (select distinct top 2 * from emp order by sal desc)t order by sal asc

Is This Answer Correct ?    1 Yes 0 No

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp whe..

Answer / r.rajivgandhi

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

These Query is correct.Try It

Is This Answer Correct ?    0 Yes 0 No

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp whe..

Answer / madhu sudhan g

Hii lets consider the table Salary having EMPNO,EMPSal columns
to find the 2nd higest salary

;WITH CTE(Sal,Row)
AS
(
select EMPSal,ROW_NUMBER() OVER(ORDER BY EMPSal) as Row from Salary
)
select sal as Salary from CTE where Row=2

Is This Answer Correct ?    0 Yes 0 No

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp whe..

Answer / ramu

by using sub quries we can do
select * from emp where sal=select max(sal) from emp where
sal<select max(sal) from emp;

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SQL Server Interview Questions

Explain the properties of a relational table?

0 Answers  

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

How to create logins using windows Authentication mode?

2 Answers  

How can we remove orphan records from a table?

0 Answers  

Can sql server be linked with other servers like oracle?

0 Answers  

What is oltp (online transaction processing)?

0 Answers  

What are the advantages of user defined function?

0 Answers  

how can u get last observation in an unknown dataset ?

0 Answers   Genpact,

Explain an automatic checkpoint

0 Answers  

How to add a new dsn with the odbc driver for sql server?

0 Answers  

how can i view structure of table in sql server? tell me that query.

10 Answers  

can any one please send sql quries most used in applications.

2 Answers  

For more SQL Server Interview Questions Click Here
Categories