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
- 6570 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how tsql statements can be written and submitted to the database engine? : Transact sql
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
When is a declare statement required?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
what is union? : Sql dba
what is a trigger in mysql? : Sql dba
What is sql partition?
How many types of triggers exist in pl/sql?
Is sql a backend?
How does postgresql compare to mysql?
How to get list of all tables from a database?
What are all the different types of indexes?
What is the difference between sql and t sql?
What is use of trigger?
how can we know the number of days between two given dates using mysql? : Sql dba
