| hi - VERY VERY URGENT [message #38655] |
Fri, 03 May 2002 18:01  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
