Answer Posted / murthy

select e.name from
(select *,row_number() over (partition by name order by
name) as Rw from #T1) e
order by e.Rw,name desc

List out the different types of locks available in sql server?

562

---

What is index in an assignment?

535

---

What is delete query?

524

---

What are views in ms sql server?

600

---

Do you know what guidelines should be followed to help minimize deadlocks?

538

---

---

What is 1nf normalization form?

601

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

590

---

Can You Use Data Mining Models In Ssrs?

97

---

How to locate and take substrings with charindex() and substring() functions?

516

---

What is role playing dimension with two examples? : sql server analysis services, ssas

597

---

How to enforce security in sql server? : sql server security

623

---

What is the purpose of grouping data in a report?

547

---

What is right outer join in sql server joins?

692

---

What is merge?

573

---

What do you mean by subquery?

587

---