Answer Posted / purabi roy(sarkar)

select top 3* from Tablename
where columnname in ( select top 7columnname from table
name order by columnname desc )
and columnname not in( select top 4columnname from
tablename order by columnname desc )
order by columnname desc

can a table be moved to different filegroup? : Sql server administration

907

---

Explain nested trigger in sql?

1004

---

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

842

---

Can we use pragma autonomous_transaction in trigger?

903

---

Describe and explain about SQL native client?

1030

---

What are the 7 disadvantages to a manual system?

904

---

What is isolation levels?

957

---

How to delete duplicate rows?

928

---

Is it true, that there is no difference between a rule and a check constraint?

970

---

How to set the current database in ms sql server?

1008

---

How to create a ddl trigger using "create trigger" statements?

1063

---

Explain the different types of backups available in sql server? : sql server database administration

861

---

What are statistics?

946

---

How to drop an existing schema in ms sql server?

1012

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

877

---