Answer Posted / avanish kumar

if you have a table emp and you have to find fourth maximum
salary from emp table then you will have to write this
query.....

select top 1 sal from (select top 4 * from emp order by sal
desc) as sal order by sal

What is the main purpose of having conversation group?

859

---

What are unicode character string data types in ms sql server?

1168

---

Explain nested trigger in sql?

1022

---

What are the advantages of using stored procedures in sql server?

973

---

How many types of the database links?

1036

---

How to get a list of columns in a view using the "sp_help" stored procedure?

995

---

What are the different normalization forms?

1062

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

972

---

What are the differences between having and where clause.

938

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

952

---

How to edit table in sql server 2017?

890

---

What are the indexes in sql server?

1054

---

What is 2nf normalization form?

1074

---

What do you understand by physical_only option in dbcc checkdb?

955

---

Explain some stored procedure creating best practices or guidelines?

881

---