Answer Posted / g

TO FIND THE 3rd,

select max(sal) from emptable where salary not in(select
distinct top 2 sal from emptable)

TO FIND THE 4th,

select max(sal) from emptable where salary not in(select
distinct top 3 sal from emptable)

TO FIND THE 5th,

select max(sal) from emptable where salary not in(select
distinct top 4 sal from emptable)

keep change top value...

What are basics of policy management?

1050

---

Explain raiserror in sql server?

964

---

Tell me what is sql profiler?

982

---

What is a covered index?

893

---

What is 'write-ahead log' in sql server 2000 ?

991

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1133

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

922

---

How to make conditional sum in ssrs?

173

---

What happens if we shrink log file in sql server?

913

---

What are the different types of normalization?

1091

---

How ssrs maintain security?

1018

---

How to move database physical files in ms sql server?

961

---

Explain the Ways to improve the performance of a sql azure database?

80

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

913

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1022

---