Answer Posted / pradip jain

select sname from (select Row_Number() over (partition by
sname
order by sname) as ROWNO,sname from student) p
order by ROWNO,sname desc


only change table name same as bobby

How to convert numeric expression data types using the cast() function?

1074

---

Explain the disadvantages of cursors?

1146

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1142

---

What is federation member?

116

---

Do you know hot add cpu in sql server 2008?

961

---

How to find the list of fixed hard drive and free space on server?

1205

---

Explain what is dbcc?

1015

---

What is SubQuery in SQL Server 2008

1028

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

912

---

What is normalization and denormalization in sql server?

1021

---

What is the use of “join” in sql server?

1104

---

What are sub reports?

204

---

What does the on update no action do?

1033

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1082

---

Explain what are the events recorded in a transaction log?

1008

---