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
- 5888 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
What is offset in sql query?
What is the difference between drop and truncate commands?
what is a trigger? : Sql dba
What is trigger and types?
explain the options of myisamchk to improve the performance of a table. : Sql dba
how many ways we can we find the current date using mysql? : Sql dba
what are the advantages of mysql in comparison to oracle? : Sql dba
Which is faster count (*) or count 1?
What are sql constraints?
Can two tables have same primary key?
What is keys and its types?
What is coalesce sql?
Is primary key clustered index?
Is progress software supports to ( pl/sql )?
Can we use the cursor's to create the collection in PL/SQL?
