update table1 set seq_no =rownum where 1=1;

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

Question Posted / priyanka

Answer Posted / priyanka

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the 'mysql' command line arguments? : Sql dba

1121

What is scalar function?

1033

What are types of joins?

949

Explain mutating table error.

1180

What is natural join in sql?

962

Is full outer join same as cross join?

952

What is user in sql?

1004

How to write a query to show the details of a student from students table whose

982

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

991

Is postgresql a server?

1031

How delete all data from all tables in sql?

932

How many commands are there in sql?

1010

Is mariadb a nosql database?

1036

What is self-join and what is the requirement of self-join?

1131

what is the difference between truncate and delete statement? : Transact sql

1045