Home » Other » Client Tools » hi - VERY VERY URGENT
hi - VERY VERY URGENT [message #38655] Fri, 03 May 2002 18:01 Go to next message
rammohan
Messages: 13
Registered: March 2002
Junior Member
Hi guys pl help me in solving the problem.

I have two tables

table 1 (TRANSACTION) table 2(MASTER)

wono number(5) trantype varchar2(2)
woqty number(5) wono number(5)
woqty number(5)

there are morethan two rows in table1 for wono.
i want to update the woqty in table1 for only
one row for each wono.
pl help me.
Re: hi - VERY VERY URGENT [message #38700 is a reply to message #38655] Tue, 07 May 2002 02:23 Go to previous message
Jai
Messages: 13
Registered: May 2002
Junior Member
Hi,
If you need to update 1 out of 2 identical records in a table,you can resort to Rowid to identify the row that you need..If you have n rows having identical values for the identifier and you need to update the
first of all identical rows,then use min(rowid) group by <colname> in your UPDATE query.

Regards
Jai
Previous Topic: Cursor with rownum - Urgent how to speed up
Next Topic: Re: Help on Dynamic SQL using Execute Immediate
Goto Forum:
  


Current Time: Fri Mar 29 08:57:51 CDT 2024