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

Explain throw statement in sql server 2008?

931

---

Can we insert data into a view?

1062

---

What is read committed?

1007

---

How many partitions a clustered index has by default in sql server 2012?

1050

---

What is difference between table aliases and column aliases? Do they affect performance?

910

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

928

---

Explain tables in SQL Azure?

120

---

What is indexed view?

927

---

What are wait types?

1019

---

Which are the third-party tools used in sql server and why would you use them?

843

---

Can you name some of the dml commands in sql?

961

---

What are dml (data manipulation language) statements in ms sql server?

924

---

How many types of stored procedures are there in sql server?

952

---

What is the use of sql profiler in sql server 2012?

841

---

Why does sql studio use a single registered database repository? : sql server management studio

952

---