Answer Posted / kavitha. r

select top 1 salary from employee where salary in (select
top n salary from employee order by salary desc) order by
salary desc

What according to you is the difference between mysql and sql server performance?

563

---

Is it safe to delete log files?

525

---

how you can configure a running aggregate in SSRS?

112

---

what's the difference between delete table and truncate table commands? : Sql server database administration

484

---

What is meant by dirty read?

557

---

---

How does clustered and non clustered index work?

515

---

What is update locks?

514

---

Which sql server is best?

518

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1120

---

Is sql different from sql server?

514

---

What is a primary index?

529

---

How to execute a sql statement using mssql_query()?

545

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

563

---

What are the basic features of a trigger in ms sql server?

568

---

Explain in brief how sql server enhances scalability of the database system?

479

---