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

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

what is log shipping? : Sql dba

0 Answers  

what is 'mysqladmin' in mysql? : Sql dba

0 Answers  

how many sql dml commands are supported by 'mysql'? : Sql dba

0 Answers  

What is procedure in pl sql?

0 Answers  

What are the components of a PL/SQL block ?

3 Answers  

Explain scalar functions in sql?

0 Answers  

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

Are subqueries better than joins?

0 Answers  

What is crud sql?

0 Answers  

Is pl sql a scripting language?

0 Answers  

Can we insert data into view?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories