Answer Posted / mangalesh porwal

HERE N IS THE NO WHICH HIGHEST NO U WANT..........
IT SURELY WORKS.....

SELECT TOP 1 * FROM (SELECT TOP N * FROM (SELECT ROLLNO FROM TABLE_NM ) AS D ORDER BY ROLLNO DESC) AS P ORDER BY ROLLNO

What is stored in the mssqlsystemresource database? : sql server database administration

988

---

What is oltp (online transaction processing)?

953

---

How to use "begin ... End" statement structures in ms sql server?

960

---

Explain in brief about Microsoft SQL server?

1014

---

What is subquery explain with example?

1009

---

how would you troubleshoot blocking? : Sql server database administration

945

---

What is extent? Types of extents?

1089

---

What is global temp table?

951

---

How to create a new login name in ms sql server?

997

---

Difference between primary key and clustered index?

936

---

How to update multiple rows with one update statement in ms sql server?

1137

---

What is the difference between mysql and sql server?

943

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1006

---

is there a column to which a default can't be bound? : Sql server database administration

969

---

Is it ok to shrink transaction log?

939

---