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

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

940

---

What is cursor in ms sql server?

1092

---

What are sparse columns?

954

---

How do I debug a stored procedure in sql server?

1030

---

What is the difference between commit and rollback?

877

---

How to create a large table with random data for index testing in ms sql server?

981

---

How to how to convert numeric expression data types using the convert() function??

990

---

How to return the second 5 rows in ms sql server?

1006

---

What is normalization? What number of normalization shapes are there?

1056

---

Where are stored procedures in sql server?

1010

---

Can you force a query to use a specific index?

889

---

Tell me what are cursors and when they are useful?

909

---

What is a result set object returned by mssql_query()?

1078

---

What do you mean by collation recursive stored procedure?

1013

---

Can two different columns be merged into single column? Show practically?

1015

---