Answer / prativa mishra

select t.c1,
(SELECT SUM(x.c2)
FROM table_name x
where x.c1 <= t.c1) as c2
from new table_name


or

select c1,
SUM(SUM(c2)) OVER
(ORDER BY c1 ROWS BETWEEN UNBOUNDED PRECEDING AND
CURRENT ROW)
AS C2
from table_name
group by c1

Answer / vinay

Select c1,sum(c2) over (order by c1) as C3 from T1

Is delete faster than truncate?

0 Answers  

---

what is timestamp in mysql? : Sql dba

0 Answers  

---

What is set serveroutput on?

0 Answers  

---

Write a unique difference between a function and a stored procedure.

0 Answers  

---

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  

---

What is data manipulation language?

0 Answers  

---

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

how can i read write files from pl/sql

3 Answers  

---

What is data type in database?

0 Answers  

---

What will happen after commit statement ?

2 Answers  

---

Why is stored procedure faster than query?

0 Answers  

---