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?
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
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know. 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.