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
Answers were Sorted based on User's Feedback
Answer / m.raghu
by using sub query answer is
update table1 set col1=(select col2 from table2 where
<cond>)
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / mglbayar
UPDATE (SELECT t1.col1 c1, t2.col1 c2
FROM table1 t1, table2 t2
WHERE t1.pk = t2.fk AND more_condition)
SET c1 = c2;
Is This Answer Correct ? | 2 Yes | 1 No |
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 |
Difference between truncate, delete and drop commands?
What are all types of user defined functions?
How would you pass hints to the sql processor?
If a cursor is open, how can we find in a pl/sql block?
Is not null in sql?
What is vector point function?
How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?
What can sql server reporting services do?
How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra
Does truncate remove indexes?
What are reports usually used for?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba