Answer Posted / sunil patel

with cte as (
SELECT DENSE_Rank() OVER(PARTITION BY ecc_dm_id_dep ORDER
BY ecc_gross_simple DESC) AS RowID,
*
FROM emp_curr_company
)
SELECT *
FROM cte
WHERE RowID = 2

How to integrate the ssrs reports in application?

936

---

What is Federation and Federation Member?

92

---

Explain transaction server explicit transaction?

879

---

What is temporal data type?

875

---

Tell me what is a linked server?

989

---

What are different types of table joins?

964

---

What is user-defined multi-statement table-valued function?

998

---

how to control the amount of free space in your index pages? : Sql server database administration

985

---

What are triggers? How do you invoke a trigger on demand?

1246

---

Name few of the dcl commands in sql?

952

---

What is the purpose of update statistics and scope_identity() function?

1053

---

Do you know clustered and non-clustered index?

933

---

How can you manage sql azure security?

101

---

What is policy management?

936

---

How to get a list of columns in a view using the "sp_help" stored procedure?

991

---