Answer Posted / amit kumar

--- Getting 4th highest salary
--- 4 can be replaced with any number

with EmpSal as
(Select *, row_number() over (order by EmpSal Desc)
as 'rownumber' from employee)

Select * from EmpSal where rownumber =4

What is checkpoint in sql server?

1056

---

How do I start sql server 2016?

853

---

What is similarity and difference between truncate and delete in sql?

1027

---

What is subquery explain with example?

1005

---

How to set database to be single_user in ms sql server?

966

---

What is the difference between writing data to mirrored drives versus raid5 drives

871

---

How to convert a unicode strings to non-unicode strings?

1028

---

What command is used to delete a table from the database in the sql server and how?

1038

---

explain different types of joins? : Sql server database administration

919

---

How to add more data to the testing table in ms sql server?

997

---

What is the new security features added in sql server 2014? : sql server security

941

---

What is public role in sql server?

1065

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1013

---

How to stop log file growing too big?

953

---

can an automatic recovery be initiated by a user? : Sql server administration

893

---