For most patients with congenital myopathy or muscular dystrophy, the treatment is largely supportive, with physical therapy, occupational therapy, management of contractures, nutrition, and genetic counseling.
Msg 2601, Level 14, State 1, Line 8. Cannot insert duplicate key row in object 'dbo.SlsPrc' with unique index 'SlsPrc1'. The duplicate key value is (IC, P, SUPQ101 , ORA3000 , BAS , GLOBAL ). The statement has been terminated. Msg 295, Level 16, State 3, Line 20. Conversion failed when converting character string to smalldatetime data type.
I would like to know if it is possible to delete duplicate records from a table with out using rowid using MYSQL only. Can use rownum. Plz help me in this regard.