| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Veerabhadrarao Narra | Date: | February 20 2006 10:27am |
| Subject: | Need Update Query Help (Urgent) | ||
| View as plain text | |||
Hi
i ahve one table table_1 and columns like col_1,col_2,col_3
col_1 col_2 col_3
1 aa aaa
2 bb
Now i want to update my table table_1 SET col_3 as bbb where max of col_1
I wrote this below Query but it shows error how to write
UPDATE table_1
SET col_3 = 'bbb'
WHERE col_1 = (SELECT max(col_1) FROM table_1)
--
Thanks & Regards,
veerabhadrarao narra,
+91-988-556-5556
| Thread | ||
|---|---|---|
| • Need Update Query Help (Urgent) | Veerabhadrarao Narra | 20 Feb |
| • Re: Need Update Query Help (Urgent) | Jeff Shapiro | 20 Feb |
| • Re: Need Update Query Help (Urgent) | Peter Brawley | 20 Feb |
