We need a Sql query to fill a column of a table of a mySql data base.
See the attached Word archive which contains the required task.
The data base is attached as well.
33 freelancers are bidding on average $19 for this job
Hi! I create your query: SET @cnt = 0; UPDATE arda a1 JOIN (SELECT id_art, @cnt:=@cnt+1 AS cntn FROM arda ORDER BY ranking DESC) a2 ON a1.id_art=a2.id_art SET `position`=a2.cntn
Hi, I am having 5 years of experience in sql pl/sql good in query writing procedures functions , triggers packages object oriented concepts partitions etc.. I am Interested in this poject. Regards S.Sreevalli
Hi team, I am having 4 year of experience in database technology.I worked on SQL server 2005,2008,2012 and 2014,My Sql workbench,php mysql.I would like to help you.you can contact me .