Answer Posted / jayakumar

please try this....

this is very usefull to you

select colunm_name from (select distinct(column_name) from
table_name where column_name is NOT NULL order by desc)
where rownum=n;

How do I view a procedure in sql server?

990

---

what is checksum in sql server.........???

1686

---

Explain index in sql server?

1012

---

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

993

---

What is the contrast amongst drop and truncate?

1034

---

What does dml stand for?

947

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

935

---

 Explain what is sql override for a source taLle in a mapping?

1012

---

What is difference between clustered index and non clustered index?

1075

---

what is a live lock? : Sql server database administration

955

---

what are defaults? : Sql server database administration

1091

---

Why use “in” clause in sql server?

1071

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1137

---

What is the latest version of microsoft sql server?

1046

---

Do comments need to go in a special place in sql server 2005?

856

---