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
- 6661 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 tables will create when we create table, what are they? : Sql dba
define sql insert statement ? : Sql dba
Is primary key always clustered index?
What is the current version of postgresql?
Do we need to rebuild index after truncate?
what is schema? : Sql dba
Can we use distinct and group by together?
how to start mysql server? : Sql dba
Is inner join faster than left join?
What is the best sql course?
If a cursor is open, how can we find in a pl/sql block?
Can we rollback truncate?
Does group by remove duplicates?
What is your daily office routine?
how to escape special characters in sql statements? : Sql dba
