SQL update the first few lines, how to modify the first 10 records in the SQL statement

update table name set a=stuff(a,3,2,'22'Where a in(select top 5 a from table name) is good to replace with stuff, there are 4 parameters in it, field name, first few characters, replace a few, replace what.

This can be solved with the row number.

Such as the student table:

Name Age.

Zhang San 20 Li Si 15

Wang 5 22, Zhao 6 21

Sun Qi 18 Yang Ba 19

Liu Jiu 24 If you want to take out the first 5 pieces of data from oldest to youngest by age, you can use the following statement:

select name, age.

fromselect name, age, row number() over (order by age desc) as rn from student) t

where rn<=5;

The result is:

Name Age.

Liu Jiu 24 Wang Wu 22

Zhao Liu, 21, Zhang San, 20

Yang VIII 19

If the value of the field is unique:

update table set field = new value where field in (select top 10 field from table);

sql server:

set rowcount 10

update table set the name of the field to be changed ='New value'

set rowcount 0

oracle writes:

update table_name set coum = coum+1 where rownum <11;

SQL Server Writing:

set rowcount 10

update table set the name of the field to be changed ='New value'

set rowcount 0

Demonstration **1 (change the specified condition to column 2 as Zhang 3 data):

update table name set [column 1]='22444', [column 3] ='asdasd'where [column 2] ='Zhang San';

Demo 2 (change the first 1000 pieces of data, set the value of column 2 to Zhang 3) update table name set [column 2]='Zhang San'where (select top 1000 [column 2] from table name);

update tablename set fieldname = ''

where you can write a condition here.

For example, where id in (1,2,3,4) only updates records with IDs 1,2,3,4.

-You can use the top keyword for example:

select top 100 * from table name.

The meaning of the statement is to display the first 100 pieces of data in the table.