jeudi 16 juillet 2015

Update current cursor position record Sql

I have table with duplicate id record.I written a query to get all record with same id.Now i want to update record id such as follows

CREATE TABLE Student1
    (`id` int,`status` int,`amount` int , `Name` varchar(10), `date` varchar(55))
;

INSERT INTO Student1
    (`id`,`status`,`amount`, `Name`, `date`)
VALUES
    (1,0,4500, 'ram', '04/02/2012'),
    (2,0,2000, 'shyam', '05/09/2013'),
    (2,0,6500, 'radhe', '11/11/2014'),
    (2,0,8000, 'radheshyam', '15/11/2013'),
    (4,0,1500, 'ghanshyam', '08/11/2014')
;

id  status  amount  Name         date
1   0       4500    ram         04/02/2012
2   0       2000    shyam       05/09/2013
2   0       6500    radhe       11/11/2014
2   0       8000    radheshyam  15/11/2013
4   0       1500    ghanshyam   08/11/2014

SqlQuery:

SELECT * FROM Student1
   where id in (SELECT id FROM Student1 GROUP BY id HAVING count(*)>1)

Expected Result :

   id status    amount     Name        date
   2    0       2000      shyam      05/09/2013
   2    0       6500      radhe      11/11/2014
   2    0       8000    radheshyam   15/11/2013

Now i want to update any two records id's to 21,211.So i am trying to get the cursor count which will return 3.After getting count i m moving

Aucun commentaire:

Enregistrer un commentaire