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 a cursor, index in sql?

1130

---

What structure can you implement for the database to speed up table reads?

1237

---

How to execute stored procedure and set temp table in sql server?

1101

---

How much does sql server 2016 cost?

1160

---

How many null values we can have in a unique key field in sql server?

1012

---

Explain the different types of joins?

1046

---

How to update values in a table with update statements in ms sql server?

1065

---

What is difference between materialized view and view?

954

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1055

---

What are different type of Collation Sensitivity?

1052

---

What is page-level compression?

1011

---

Explain how to integrate the ssrs reports in application?

1063

---

Is it safe to delete log files?

978

---

What is federation member?

116

---

How to connect a database with sql express.?

1119

---