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...

write sql query following source are
EmpID, Salary
101 1000
102 2000
103 3000
I want the output format like following
empid,sal,composite_sal
101 1000 1000
102 2000 3000
103 3000 6000

Answer Posted / mukesh

select empid,
salary,
sum(salary) over(order by empid rows unbounded
preceding) composite_sal from source

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the attributes of the cursor?

952


What is flashback in Oracle?

983


What is a lookup table in oracle?

946


How do I start tns listener?

999


How to loop through a cursor variable?

1032


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

970


What is a trigger oracle?

1053


Is there an oracle sql query that aggregates multiple rows into one row?

949


while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4309


what is the scripts in data base?

2099


How to invoke the original export import utilities?

1003


IS it possible to built the oracle database without setting the kernal parameters?

2297


What is oracle instant client?

986


Explain the use of inctype option in exp command.

993


Difference between pre-select and pre-query

1056