Answer / 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;

Answer / glibwaresoftsolutions

• 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;

Answer / hr@tgksolutions.com

• 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;

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

Does execute immediate commit?

0 Answers  

---

What is optimistic concurrency control? : Transact sql

0 Answers  

---

What is CYCLE/NO CYCLE in a Sequence?

2 Answers  

---

What is a primary key example?

0 Answers  

---

What is pl/sql language case sensitive?

0 Answers  

---

What is form and report?

0 Answers  

---

What are the key differences between SQL and PL SQL?

0 Answers  

---

What is a design view?

0 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

Can we rollback truncate?

0 Answers  

---

What is the use of count (*) in sql?

0 Answers  

---