Answer Posted / chandra sekhar

CREATE A EMPLOYEES TABLE WITH THE COLUMNS
EMPLOYEEID,EMPLOYEENAME,DEPARTMENT,SALARY
AND INSERT THE RECORDS INTO THE TABLE

with cte
as (
select dense_RANK() over(partition by department order by salary desc) as Rank,
employeeID,employeename,department,salary from
Employees)
select x.employeeID,
x.employeename,
x.department,
x.salary,
x.rank
from cte x
where x.Rank=2
order by x.Salary


NOTE:here i am finding 2nd highest salary from the each department

Explain concepts of analysis services?

1018

---

Explain about Joins?

1039

---

How do you implement session management in SQL Server mode?

1160

---

Explain how does the report manager work in ssrs?

1002

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

938

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1022

---

What is report server project?

155

---

What are distinctive joins find as a part of sql?

1007

---

Describe in brief system database.

1077

---

What is a transactions?

1090

---

How efficient you are in oracle and SQL server?

1224

---

How to create an index on a view?

1143

---

Does index speed up select statements?

1079

---

How to include date and time values in sql statements?

1146

---

What is 2nf in normalization?

1058

---