update emp_test a set empno=7469 where (select empno from (select rownum r

Write one update command to update seqno field of a table
on the basis of row number.

Question Posted / rk

Answer Posted / rk

update emp_test a set empno=7469 where (select empno from
(select rownum r,empno from emp_test) where r=6 )=a.empno

use seqno in place of empno

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

976

Why is sharding used?

989

Enlist the characteristics of pl/sql?

1791

Which one is better subquery or joins?

1054

How many types of literals are available in pl sql?

1109

Can pl sql procedure have a return statement?

1017

What is the mutating table and constraining table?

1023

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1114

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1034

Should I use mbr or gpt?

1022

How do I run a sql trace?

951

Show how functions and procedures are called in a pl/sql block.

1112

How can you fetch first 5 characters of the string?

1007

Explain select statements in sql?

1049

What is difference between procedure and trigger?

971