Help query
806692Oct 20 2010 — edited Oct 20 2010I have a table with data as shown below.
ID OBJ STATUS
4 Account 100
5 Account 100
6 Account 100
7 Account 100
14 Response 100
15 Response 100
16 Response 100
17 Response 100
I want to update only first 2 records for both the OBJ (Account and Response) to status 200.
Can you please provide an update query to perform this task.
OUTPUT:
ID OBJ STATUS
4 Account 200
5 Account 200
6 Account 100
7 Account 100
14 Response 200
15 Response 200
16 Response 100
17 Response 100
Thanks in advance.