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 raid? : Sql server database administration

968

---

How to scale out a federation by Sql statement?

116

---

what is isolation level at dead lock?

2088

---

How to receive returning result from a query?

1033

---

How to display a past time in days, hours and minutes?

963

---

What is use of dbcc commands?

1016

---

how can you attach more than 20 ldf files in sql server

1946

---

what are candidate key, alternate key and composite key? : Sql server database administration

851

---

What is a transactions?

970

---

What are the pre-defined functions in the sql server?

1026

---

What are the instances when triggers are appropriate?

925

---

Do you know hot add cpu in sql server 2008?

896

---

Explain transaction server distributed transaction?

918

---

what are isolation levels? : Sql server database administration

908

---

What are temporal tables in sql server 2016?

838

---