Answer Posted / bobby

select ename from (select Row_Number() over (partition by
ename
order by ename) as ROWNO,ename from emp) p
order by ROWNO,ename desc

What extended events?

564

---

What are exact numeric data types in ms sql server?

518

---

How to sort query output in descending order in ms sql server?

555

---

What is unique key constraint?

640

---

What is the difference between a stored procedure and a user defined function?

552

---

---

What do you understand by coalesce in sql server?

510

---

Do you know nested transaction?

526

---

What is the Difference Between Primary and Foreign Key?

594

---

How many types of schemas are there?

535

---

How to drop an existing user defined function in ms sql server?

576

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1064

---

Does server sql treat char as a variable-length or fixed-length column?

595

---

What is the fastest way to permanently delete a 1 million row table named customers?

609

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

593

---

Do you know what are various aggregate functions that are available?

533

---