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
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 are secondary keys?
Does sql*plus also have a pl/sql engine?
Can we write dml inside a function in sql server?
What is a column in a table?
What is the use of double ampersand (&&) in sql queries? Give an example
How do I order columns in sql?
What is the most important ddl statements in sql are?
What is query execution plan in sql?
What is your daily office routine?
What is anonymous block in sql?
Why functions are used in sql?
Describe different types of general function used in sql?
What is normalization sql?
What does an inner join do?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?