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 is normalization? What number of normalization shapes are there?

1056

---

What is the primary use of the model database?

1021

---

how many bits ip address consist of? : Sql server database administration

849

---

what are the different ways to return the rowcount of a table?

945

---

How do I open port 1433?

883

---

How to define and use table alias names in ms sql server?

1045

---

What are the restrictions that views have to follow? : SQL Server Architecture

948

---

What is query parameter in ssrs?

143

---

How do I completely remove sql server instance?

1026

---

what is spatial nonclustered index

945

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

901

---

How do I perform an unattended install of sql server 2000?

1020

---

How many levels of sp nesting are possible?

961

---

What are the benefits of filtered indexes?

977

---

Explain syntax for viewing trigger?

888

---