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

How to update salary of employees department wise?

Answer Posted / k v koteswara rao

UPDATE employees SET salary=DECODE(department_id,10,salary+1000,20,salary+2000,30, salary+3000,salary);

Is This Answer Correct ?    18 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a database? : Sql dba

1241


What do you understand by pl/sql records?

1062


How to write html code in pl sql?

1161


What are the types of index in sql?

1124


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2063


What is trigger point?

1058


Can we create view in stored procedure?

1026


What does select count (*) mean in sql?

1075


what is not null constraint? : Sql dba

1078


Why commit is not used in triggers?

1091


What is the difference between nested table and varray?

1052


What is difference between joins and union?

1197


What types of commands can be executed in sql*plus?

1167


What is an ndf file?

1067


How is sql used in oracle?

1039