Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

i have a table like this. i want to output like this
c1 c2 c1 c2

1 10 1 10
2 20 2 30
3 30 3 60
4 40 4 100
5 5 5 105

c1 and c2 are columns in a table .i want output like this

c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5.

write a sql query.pls help this
i want urgent.

Question Posted / ramesh

Answers were Sorted based on User's Feedback



i have a table like this. i want to output like this c1 c2 c1 c..

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

Is This Answer Correct ?    17 Yes 2 No

i have a table like this. i want to output like this c1 c2 c1 c..

Answer / vinay

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

Is This Answer Correct ?    13 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What is left join in sql?

0 Answers  

Wat is SGA ?

3 Answers   ABB,

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

When to use inner join and left join?

0 Answers  

Which is faster count (*) or count 1?

0 Answers  

Explain the insert into statements in sql?

0 Answers  

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 Answers  

What is an index in sql with example?

0 Answers  

what is subquery? : Sql dba

0 Answers  

How do I kill a query in postgresql?

0 Answers  

What is dml with example?

0 Answers  

What is meant by cursor in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories