View Single Post
  #4 (permalink)  
Old 08-31-10, 00:03
rajasekhar857 rajasekhar857 is offline
Registered User
 
Join Date: Mar 2010
Posts: 9
Table: ABC
A B C D E F G H
50586 152476 Dextromethorphan-Guaifenesin 10-100 mg/5 mL Tussin DM 10 mg-100 mg/5 mL Syrup R
89446 433219 Dextromethorphan-Guaifenesin 10-100 mg/5 mL Tussin DM 10 mg-100 mg/5 mL Syrup A
165511 433219 Dextromethorphan-Guaifenesin 10-100 mg/5 mL Tussin DM 10 mg-100 mg/5 mL Syrup A

i want to update Table ABC COLUMN H as 'I' If all columns matches except A

WHAT IS THE UPDATE QUERY IN DOING SO.

SOMEWHERE TRIED LIKE

UPDATE TABLE ABC SET H='I' WHERE A IN (SELECT MIN(A) FROM ABC GROUP BY C HAVING COUNT(*)>1)

I AM HAVING MORE TAHN 1.5 LAKH RECORDS IN MY TABLE.HOW TO UPDATE IF IT MATCHES ABOVE CRITERIA.....
Reply With Quote