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