I have a table like this structure: col1 col2 1 row1 * 2 row1 3 row1 4 ...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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?
UPDATE sometable SET somecolumn = '*' WHERE col1 IN (SELECT MIN(col1) FROM sometable GROUP BY col2)
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Greg Low
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ...continue reading
A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.