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 reportserver and reportservertempdb ?

152

---

How retrieve field names from the table in SQL through JAVA code?

1914

---

How to create function without parameter in sql server?

1060

---

Define candidate key, alternate key, and composite key.

925

---

How to find out the list schema name and table name for the database?

942

---

What are the mathematical functions supported by sql server 2005?

1072

---

What is recompile sql server?

1044

---

Which language rdl files made of?

130

---

Write down the syntax and an example for create, rename and delete index?

987

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1050

---

What is the maximum size of a row in sql server?

969

---

How to return the date part only from a sql server datetime datatype?

1106

---

Find first and last day of current month in sql server

1028

---

What is the difference between system objects and user objects?

1166

---

What are the different types of normalization?

1167

---