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 Narra20 Feb
  • Re: Need Update Query Help (Urgent)Jeff Shapiro20 Feb
  • Re: Need Update Query Help (Urgent)Peter Brawley20 Feb