Answer Posted / vishal patel

with cte as (
SELECT ROW_NUMBER() 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 the downside of using udf?

1109

---

How does using a separate hard drive for several database objects improves performance right away?

932

---

What are the purposes and advantages stored procedure?

959

---

What are the new features of sql server 2008 r2 reporting service?

209

---

How to create sub reports?

242

---

How to disable triggers using "disable trigger"?

1056

---

Explain the disadvantages/limitation of the cursor?

963

---

What is the full meaning of dml?

952

---

What is 3nf normalization?

995

---

What is blocking?

1066

---

Is the order of columns in the set clause important in ms sql server?

969

---

What objects does the fn_my_permissions function reports on? : sql server security

1034

---

What is database black box testing?

1033

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1077

---

How to get the definition of a trigger back?

1002

---