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

mention different types of relationships in the dbms?

1092

---

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

1130

---

Tell me something about security and sql azure?

116

---

What is the maximum size per database for sql server express?

1103

---

What are different types of views?

989

---

Write a query to find 5th highest amount paid from the customer table.

994

---

What are the indexes in sql server?

1191

---

Do you know what is difference between stored procedure and user defined function?

1156

---

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

1108

---

what is the difference between Delete and Truncate command in SQL

1201

---

Explain different types of self contained sub query?

1107

---

How to list all schemas in a database?

1103

---

How do I determine how many instances of sql server are installed on a computer?

1059

---

Tell me can we use custom code in ssrs?

1055

---

When is the use of update_statistics command?

1059

---