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

What is BLOCK statements in SQL?

1227

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1003

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

143

---

What action plan is preferred if sql server is not responding?

1056

---

What is triggers and its types?

974

---

Does an index slow down updates on indexed columns?

934

---

Tell me about joins in database system and explain each in detail.

1017

---

What is normalization process?

1124

---

What is store procedure? How do they work?

969

---

What is acid db?

857

---

What is the use of for clause?

1062

---

How can I track the changes or identify the latest insert-update-delete from a table?

927

---

How do I create a trace in sql server?

987

---

What is the purpose of the model database?

985

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

941

---