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 are partitioned views and distributed partitioned views?

1064

---

What is raiseerror? What is raiseerror?

1193

---

Define Business Edition in SQL Azure?

102

---

Define views.

1070

---

Tell me in brief how sql server enhances scalability of the database system?

1040

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1119

---

How secure is sql server database?

1067

---

What is a transact-sql statement batch in ms sql server?

1073

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

996

---

Why we should not use triggers?

1014

---

How to handle error or exception in sql?

1040

---

If a stored procedure is taking a table data type, how it looks?

6521

---

What are the various editions of sql server 2017 that are available in the market?

940

---

Explain what is scheduled job and how to create it?

1026

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1127

---