Answer Posted / suprotim agarwal

CREATE TABLE #Employees (EmpID int, EmpName varchar(10),
Salary int)
INSERT #Employees SELECT 1,'Tim',345345
INSERT #Employees SELECT 2,'Jill',76845
INSERT #Employees SELECT 3,'Kathy',234545
INSERT #Employees SELECT 4,'Jack',74564
INSERT #Employees SELECT 5,'Harry',56756456
INSERT #Employees SELECT 6,'Arnol',75675
INSERT #Employees SELECT 7,'Dave',76566
INSERT #Employees SELECT 8,'Zinnade',58776
INSERT #Employees SELECT 9,'Iflar',345567
INSERT #Employees SELECT 10,'Jimmy',76766

Highest Salary Of an Employee

SELECT EmpName, Salary
from
(
SELECT EmpName, Salary, Row_Number() OVER(ORDER BY SALARY
DESC) AS 'Salaries'
FROM #Employees
) emp
WHERE Salaries = 1

2nd highest salary


SELECT EmpName, Salary
from
(
SELECT EmpName, Salary, Row_Number() OVER(ORDER BY SALARY
DESC) AS 'Salaries'
FROM #Employees
) emp
WHERE Salaries = 2

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1214

---

What are the authentication modes in sql server? How can it be changed?

1193

---

What are the purposes of floor and sign functions?

1019

---

How many partitions a clustered index has by default in sql server 2012?

1139

---

Explain different types of Normalization.

1903

---

How do I edit a stored procedure in sql server?

971

---

What is difference between temp table and cte?

1073

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

1038

---

Explain timestamp datatype?

1022

---

whats new about truncate in sql server 2008?

2555

---

What is dml command?

1020

---

Explain an automatic checkpoint

1017

---

What is an indexed view?

1007

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1022

---

What is the log shipping?

1063

---