Interested to Buy Any Domain ? << Click Here >> for more details...
how can we replace the particular column value of a resulted
set of executed query? I mean write down a sql query to
chane the particular column's value of a resulted set of
executed query
- 3 Answers
- 6314 Views
- I also Faced
- E-Mail Answers
Answer Posted / suma
select decode(salary,2500,1000,3000,2500, 3000) from
employees;
This query will replace the salary column value from
employees.
If the salary is 2500 then 1000 is displayed in the
resultset, else if 3000 then 2500 will be displayed esle
2000 is displayed.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does sql backup shrink transaction log?
How do you use a while loop in pl sql?
Can a primary key be a foreign key?
What is the difference between nvl function, ifnull function, and isnull function?
How do I write a cron which will run a sql query and mail the results to agroup?
what is recursive stored procedure? : Sql dba
What is trigger and how to use it in sql?
What are aggregate and scalar functions?
What is difference between pls_integer and integer?
What are different functions in sql?
What are two statement types in sql?
Which is better trigger or stored procedure?
What are sql data types?
What is the difference between a subquery and a join?
explain about mysql and its features. : Sql dba
