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;

What is the difference between a stored procedure and a user defined function?

632

---

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

687

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

715

---

What do you understand by triggers and mention the different types of it?

570

---

What command would you use to add a column to a table in sql server?

858

---

---

How to create sub reports?

196

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

721

---

What is rolap and its advantage? : sql server analysis services, ssas

749

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

7611

---

What is difference between temp table and cte?

630

---

What are the database roles? : sql server security

647

---

What were the latest updates to SQL Azure service?

102

---

What are the advantages of using a stored procedure?

633

---

how to take backup bcp out for a column in table in sql server?

1716

---

How to use copy and concatenate commands in SQL?

693

---