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 difference between join and natural join?

477

---

How to modify an existing stored procedure in ms sql server?

530

---

What is sql stored procedure?

600

---

What do you mean by an execution plan? How would you view it?

493

---

What are different backups available in sql server?

606

---

---

What is SQL Azure Federations?

98

---

Will count(column) include columns with null values in its count?

666

---

Define cursor locking

550

---

What are the types of ssrs?

108

---

What is resource db in sql server?

596

---

What is a select query statement in ms sql server?

578

---

Is truncate a dml command?

502

---

Does a server store data?

500

---

What is an indexed view?

580

---

Explain powershell included in sql server 2008?

609

---