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

What has stored procedures in sql and how we can use it?

1013

How do I enable sql encryption?

964

How do you go back in sql?

939

What does select * from mean in sql?

3063

What is multiple columns?

1000

Can we have two clustered index on a table?

963

Does execute immediate commit?

1147

What is the purpose of normalization?

995

What does data normalization mean?

896

explain the options of myisamchk to improve the performance of a table. : Sql dba

949

how do you control the max size of a heap table? : Sql dba

918

What is schema in sql example?

1085

Can we use join in subquery?

1021

what are the authentication modes in sql server? How can it be changed? : Sql dba

1315

Does a user_objects view have an entry for a trigger?

958