Answer Posted / premsagar12

SELECT DISTINCT(A.SAL),ENAME FROM EMP A WHERE &N=(SELECT
COUNT(DISTINCT(B.SAL )) FROM EMP B WHERE A.SAL<=B.SAL);

what is a sub-report?

132

---

How to drop an existing table?

957

---

Explain full-text indexing?

913

---

What function does a database engine serve in the sql server?

984

---

What is the recovery model? List the types of recovery model available in sql server?

839

---

Can I save my report as html, excel or word? : sql server management studio

904

---

Explain features of analysis services?

922

---

What is page-level compression?

902

---

Tell me what are the essential components of sql server service broker?

884

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1799

---

How you can get the list of largest tables in a database?

942

---

What are parameterized reports? What are cascading parameters in ssrs reports?

148

---

Do you know what is xpath?

1003

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1064

---

What are advantages of ssrs or why we should use ssrs?

129

---