Q
Problem solve Get help with specific problems with your technologies, process and projects.

Update table rows in SQL Server 2000

How can I update the first row of a group? I have a table like this structure: col1 col2 1 row1 * 2 row1 3 row1 4 row2 * 5 row2 6 row2 I want to update the col1 field of the record with *. That means I need to update the first row of the distinct col2 field. How can I do this with SQL Server 2000?

How can I update the first row of a group?

I have a table like this structure: col1     col2 1           row1 * 2           row1 3           row1 4          ...

row2 * 5           row2 6           row2

I want to update the col1 field of the record with *. That means I need to update the first row of the distinct col2 field.

How can I do this with SQL Server 2000?

Is there any order to the rows at all, apart from the col2 value? If not, how would you know which row to update? If col1 does have values in it like the ones shown, you'd use an update like:

UPDATE sometable SET somecolumn = '*' WHERE col1 IN (SELECT MIN(col1) FROM sometable GROUP BY col2)

This was last published in February 2007

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close