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 |
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is number function in sql?
What is clause in sql?
What is right join in sql?
how to use regular expression in pattern match conditions? : Sql dba
how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?
What are the built in functions of sql?
How do I turn a list into a table?
What is a nested table in word?
What is the difference between anonymous block and named blocks?
What is the difference between database trigger and stored procedure?
What is latest version of sql?