Write one update command to update seqno field of a table
on the basis of row number.
- 4 Answers
- 15640 Views
- HCL, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is the use of count (*) in sql?
What is an escape character in sql?
Why is sql better than hql?
Can we create index on primary key?
What is rename command in sql?
What are field types?
What is attribute indicator in pl sql?
I need a function for a train ticket reservation please answer it thanks in advance
what is the difference difference between procedure and packages
What is java sql connection?
Does truncate need commit?
Is sql a programming?
What is varray in pl sql?
What is procedure and function in sql?
What are the main features of cursor?
