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
- 6478 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
how many values can the set function of mysql take? : Sql dba
What are character functions in sql?
what is the difference between $message and $$message? : Sql dba
how to fetch common records from two tables? : Sql dba
What is trigger in sql and its types?
What is primary key and foreign key?
What does 0 mean in sql?
What is the difference between join and natural join?
What is equi join in sql?
What is data control language?
What is the maximum database size for sql express?
What is the source code of a program?
Explain ddl statements in pl/sql?
How do sql databases work?
What is the importance of sqlcode and sqlerrm?
