Hi all,

I need ur .

I have data like this.


Table name : mytable.

------------------------------------------------------------
sno Sem mark1 mark2
-----------------------------------------------------------
1 1 71 0
2 1 85 0
3 1 80 0
4 2 10 0
5 2 20 0
6 2 30 0
---------------------------------------------------------------

I want an update query to update all mark2 field have the same as mark1
field where SEM = 1

that is , The output after the updation is like :

------------------------------------------------------------
sno Sem mark1 mark2
-----------------------------------------------------------
1 1 71 71
2 1 85 85
3 1 80 80
4 2 10 0
5 2 20 0
6 2 30 0
---------------------------------------------------------------

Please give me the update Query.


Thanks in Advance.

with warm Regards,
Thangaraju

update TABLENAME set Mark2 = Mark1 where SEM = 1

<gold.study@gmail.com> wrote in message
news:1162018244.021126.326050@m7g2000cwm.googlegro ups.com...
> Hi all,
>
> I need ur .
>
> I have data like this.
>
>
> Table name : mytable.
>
> ------------------------------------------------------------
> sno Sem mark1 mark2
> -----------------------------------------------------------
> 1 1 71 0
> 2 1 85 0
> 3 1 80 0
> 4 2 10 0
> 5 2 20 0
> 6 2 30 0
> ---------------------------------------------------------------
>
> I want an update query to update all mark2 field have the same as mark1
> field where SEM = 1
>
> that is , The output after the updation is like :
>
> ------------------------------------------------------------
> sno Sem mark1 mark2
> -----------------------------------------------------------
> 1 1 71 71
> 2 1 85 85
> 3 1 80 80
> 4 2 10 0
> 5 2 20 0
> 6 2 30 0
> ---------------------------------------------------------------
>
> Please give me the update Query.
>
>
> Thanks in Advance.
>
> with warm Regards,
> Thangaraju
>

(This seems like a class assignment where the person hasn't really attempted
to solve the problem themselves.)

Often, the quality of the responses received is related to our ability to
'bounce' ideas off of each other. In the future, to make it easier for us to
give you ideas, and to prevent folks from wasting time on already answered
questions, please:

Don't post to multiple newsgroups. Choose the one that best fits your
question and post there. Only post to another newsgroup if you get no answer
in a day or two (or if you accidentally posted to the wrong newsgroup -and
you indicate that you've already posted elsewhere).

If you really think that a question belongs into more than one newsgroup,
then use your newsreader's capability of multi-posting, i.e., posting one
occurrence of a message into several newsgroups at once. If you multi-post
appropriately, answers 'should' appear in all the newsgroups. Folks
responding in different newsgroups will see responses from each other, even
if the responses were posted in a different newsgroup.




--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


<gold.study@gmail.com> wrote in message
news:1162018244.021126.326050@m7g2000cwm.googlegro ups.com...
> Hi all,
>
> I need ur .
>
> I have data like this.
>
>
> Table name : mytable.
>
> ------------------------------------------------------------
> sno Sem mark1 mark2
> -----------------------------------------------------------
> 1 1 71 0
> 2 1 85 0
> 3 1 80 0
> 4 2 10 0
> 5 2 20 0
> 6 2 30 0
> ---------------------------------------------------------------
>
> I want an update query to update all mark2 field have the same as mark1
> field where SEM = 1
>
> that is , The output after the updation is like :
>
> ------------------------------------------------------------
> sno Sem mark1 mark2
> -----------------------------------------------------------
> 1 1 71 71
> 2 1 85 85
> 3 1 80 80
> 4 2 10 0
> 5 2 20 0
> 6 2 30 0
> ---------------------------------------------------------------
>
> Please give me the update Query.
>
>
> Thanks in Advance.
>
> with warm Regards,
> Thangaraju
>