Answer Posted / ganesh prasad

all are not working properly incase repeat salary
this one is correct to finding 4th highest salary try run
your system then call me 9438183722

select min(deptsal) from dept where deptsal in ( select
distinct top 4 deptsal from dept order by deptsal desc)

How do you manipulate data?

497

---

Why do we partition data?

616

---

what is spatial nonclustered index

544

---

How many triggers are possible per table?

629

---

How do you trace the traffic hitting a sql server?

618

---

---

What is a system database and what is a user database?

581

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

561

---

How is a full-text index updated?

540

---

Do you know what are various aggregate functions that are available?

527

---

How to list all user names in a database?

590

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

532

---

Define left outer join in sql server joins?

563

---

How to create percentile function?

108

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

511

---

How to disable triggers using "disable trigger"?

562

---