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
- 6457 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
Explain select statements in sql?
what is column? : Sql dba
What are properties of the transaction?
How to combine two stored procedures in sql?
Why do we use set serveroutput on?
How do I know if I have sql express or standard?
How do you copy a table in sql?
How many sql commands are there?
What are the types of operators available in sql?
What types of commands can be executed in sql*plus?
What is sql clause?
What is anonymous block in sql?
How many primary keys can a table have?
What are the syntax and use of the coalesce function?
What are procedures used for?
