Interested to Buy Any Domain ? << Click Here >> for more details...
Write one update command to update seqno field of a table
on the basis of row number.
- 4 Answers
- 17366 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 an ndf file?
What is not in sql?
what is a database? : Sql dba
What is difference between procedure and trigger?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What are the query optimization techniques?
Mention what are the benefits of pl/sql packages?
How do I write a sql query in pgadmin 4?
How do I start sql from command line?
Does user triggers have entry for trigger with compilation errors?
What can sql server reporting services do?
How many scalar data types are supported in pl/sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
explain mysql aggregate functions. : Sql dba
What is consistency?
