Answer Posted / nashiinformaticssolutions

• CTE: Temporary result set defined using WITH and reusable within the query. Improves readability for complex queries.
• Subquery: Nested query executed each time it is called. Example:
WITH SalesCTE AS (
SELECT employee_id, SUM(sales) AS total_sales
FROM sales
GROUP BY employee_id
)
SELECT * FROM SalesCTE WHERE total_sales > 5000;

Do ddl statements need commit?

963

---

What do you mean by “trigger” in sql?

1075

---

Is a foreign key always unique?

937

---

Can we use ddl statements in stored procedure sql server?

1006

---

What is rank dense_rank and partition in sql?

1028

---

Is vs as in pl sql?

984

---

What is sql resultset?

982

---

What do we need to check in database testing?

1017

---

Explain the types of joins in sql?

1033

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1002

---

What's the procedure?

924

---

Is sql a oracle?

976

---

What are the dml statements?

1141

---

What is an invalid partition table?

1023

---

What is scalar data type in pl sql?

1066

---