Answer Posted / parmesh m

select top 1 salary from Employee where salary in (
select top n salary from Employee
group by salary
having count(salary )< n+1
order by salary desc )
order by salary

How to write a query with an inner join in ms sql server?

1053

---

What is the difference between online clustering and Offline clustering?

2419

---

Explain about SQL server 2005?

983

---

Explain insert into select statement?

963

---

How to rebuild the master database?

1084

---

How you can get a list of all the table constraints in a database?

958

---

What is SQL Server?

1220

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

1051

---

What is the difference between functions and stored procedures?

1167

---

How to see existing views in ms sql server?

1049

---

What is the maximum size of a row in sql server?

970

---

Explain how dts is used to extract, transform and consolidate data?

1001

---

What are the advantages of paper records?

971

---

How to make a remote connection in a database?

980

---

How you provide security to cube? : sql server analysis services, ssas

970

---