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

What is sql server profiler trace data file?

578

---

What are the authentication modes in sql server? How can it be changed?

592

---

How to execute a sql statement using mssql_query()?

538

---

How to perform key word search in tables?

527

---

what is memory-optimized nonclustered indexes

546

---

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1497

---

What is etl - extraction, transformation, and loading?

520

---

What is the importance of three tier architecture?

601

---

How to execute multiple stored procedures at one time in sql server?

499

---

What are page splits? : SQL Server Architecture

537

---

What is the difference between ‘having’ clause and a ‘where’ clause?

540

---

what is the difference between Delete and Truncate command in SQL

620

---

what is create database syntax? : Sql server database administration

598

---

Explain about sql server login?

586

---

What are relationships and mention different types of relationships in the dbms

550

---