Wednesday, August 1, 2012

Satellite Healthcare Interview Questions

http://www.satellitehealth.com/

Interview questions:
1) Write a program to sum elements in array
int [] numbers = { 9, 1, 2, 7 }
Hint : Use LINQ as well as normal for-loop

2) Static variable vs Non-static variable.

3) Find the n-th highest salary of an employee.
Answer:
SELECT TOP 1 salary
FROM
(
SELECT DISTINCT TOP
6 salary
FROM
employee
ORDER BY salary DESC)
a
ORDER BY salary


No comments:

Post a Comment