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


what is syntex second or third highest salary.


thanks & Regards
Dhirendra sinha

Answers were Sorted based on User's Feedback



what is syntex second or third highest salary. thanks & Regards Dhirendra sinha..

Answer / sagar dhande

select top 2(salary) from (select top 3 (salary) from
dbo.employee order by salary desc)
order by salary

Is This Answer Correct ?    3 Yes 1 No

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha..

Answer / praveen singh

select min(salary) from salary where salary in(select top 3
salary from salary order by salary desc)

Is This Answer Correct ?    3 Yes 2 No

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha..

Answer / satish

select max(sal) from emp e1 where 1< (select count(distinct sal) from emp e2 where e1.sal <= e2.sal)

To make it generic if u want N'th highest salary;

select max(sal) from emp e1 where (N-1)< (select count(distinct sal) from emp e2 where e1.sal <= e2.sal)

And to get the N'th min sal :

select min(sal) from emp e1 where (N-1)< (select count(distinct sal) from emp e2 where e1.sal >= e2.sal)

Is This Answer Correct ?    1 Yes 0 No

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha..

Answer / veeresh kethari

with Topsal (EmpID,Ename,Sal,Dno,Topsal) as
(select *,row_number() over(order by sal) Topsal from emp)
select top 2 EmpID,Ename,Sal,Dno from Topsal order by sal desc

Is This Answer Correct ?    1 Yes 0 No

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha..

Answer / vikas kant

---To get 2nd highest salary----

select Top 1 salary from Emp where marks in(select top 2
salary from Emp order by salary desc)

---To get 3rd highest salary----

select Top 1 salary from Emp where marks in(select top 3
salary from Emp order by salary desc)



Regards Vikas Kant

Is This Answer Correct ?    0 Yes 0 No

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha..

Answer / anil tiwari

select Top2(salery)from (select Top3 (salery) from tab1
order by salery DESC)order by salery.

Is This Answer Correct ?    0 Yes 0 No

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha..

Answer / dipti saxena

select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=3
MINUS
select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=1

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More SQL Server Interview Questions

what is the cursor life span?

5 Answers   Evalueserve, HG,


What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  


What are acid properties of transaction?

0 Answers  


is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  


Explain the different types of backups available in sql server? : sql server database administration

0 Answers  


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  


Which table keeps information about stored procedures?

0 Answers  


What do you understand by hotfixes and patches in sql server?

0 Answers  


What command would you use to create an index?

0 Answers  


If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  


what is the difference between openrowset and openquery?

0 Answers  


I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 Answers   Techno Solutions,


Categories