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

Why truncate is ddl command?

1070

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2934

---

How does stuff differ from the replace function?

1019

---

What is normalization and its types?

1041

---

Can select statements be used on views in ms sql server?

1069

---

What is factless fact table? : sql server analysis services, ssas

1039

---

explain different types of cursors? : Sql server database administration

1095

---

How do I find the size of a sql server database?

932

---

Can we insert data if clustered index is disabled?

946

---

How to disable triggers using "disable trigger"?

1061

---

How do you delete a data source?

1014

---

What is reference section?

1009

---

What is GUID in sql server?

1171

---

Explain how to maintain a fill factor in existing indexes?

998

---

What is the difference between mysql and sql server?

1030

---