Closed

Sql query for a mySql database

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.

Skills: Database Development, Database Programming, MySQL, SQL

See more: convert mysql query sql, software write mq4, software write chip epson, useful software write book, software write web specs, software write edid, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, query remote database mysql, mysql query remote database, software write technical manual

About the Employer:
( 0 reviews ) Peru

Project ID: #11822339

33 freelancers are bidding on average $19 for this job

truongnguyen86

Hello there, i'm expert on MySQL, i've done many tasks with ranking like this with order before, i think i can finish it in max 2 hours. Pls give me the table including the data, i can start immediately. Waiting for yo More

$35 USD in 1 day
(123 Reviews)
6.3
danale72

Hi Please try me on this. All the best Alexei

$15 USD in 1 day
(54 Reviews)
5.4
BitLabs

Hello, I have gone through your outsourced requirements "Sql query for a mySql database" and have analyzed that I have right skills (Database Development, Database Programming, MySQL, SQL) to execute your esteemed More

$18 USD in 1 day
(30 Reviews)
5.5
mondersky

I have an idea how to do it, I just need a sample of your database to test my query (you forgot to attach it). can you pease send it to me? thanks

$12 USD in 1 day
(29 Reviews)
5.0
davedcb

Hello, I am interested in your project. I am a software engineer and I have professional experience with MySQL. Thank you, Best regards, David

$25 USD in 1 day
(23 Reviews)
4.1
phiona06

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`=[url removed, login to view]

$11 USD in 1 day
(12 Reviews)
3.9
harishpanoor

Script is ready, If you need I can give it right now Professional Experience - Highlights • 8+ years of experience in MS SQL Server development • 6+ years of experience in C# [url removed, login to view] application development • 2+ ye More

$15 USD in 0 days
(6 Reviews)
3.6
rambanstola

A proposal has not yet been provided

$10 USD in 0 days
(4 Reviews)
3.1
ankita0389

I am a faculty teaching the topic of DBMS. I have the solution of this problem, I can customize it and provide to match it your requirements.

$12 USD in 1 day
(7 Reviews)
3.3
DemonDeveloper

We are team of excellent developers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description for project More

$12 USD in 0 days
(4 Reviews)
2.0
sberreta

Hello! I can write the query you are needing! I'm a software engineer, developer and work designing databases and working with mySQL for more than 13 years. I am sure we can work this out and get the best result you More

$20 USD in 1 day
(2 Reviews)
1.9
webxtechin

Hi! CAN DO THIS NOW I am Expert in PHP,MYSQL,HTML5-HTML,JAVASCRIPT,CSS,AJAX etc..... I have 5+yr experience in developing as well as designing field... I can do this work easily and quickly..... Thankyou wa More

$10 USD in 1 day
(5 Reviews)
1.6
Krazah

SOFTWARE DEVELOPER ( C++ / Python / C / JAVA ) Highly motivated Software developer with over 3 years of experience designing and developing desktop and web applications. I have a keen interest in scalable software arc More

$12 USD in 0 days
(1 Review)
1.7
shrikantkhode

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 [url removed, login to view] can contact me .

$16 USD in 1 day
(0 Reviews)
0.0
$10 USD in 0 days
(0 Reviews)
0.0
$16 USD in 10 days
(0 Reviews)
0.0
fcbilucas

I have advanced experience of SQL, I can assure the quality in this service and deliver the agreed deadline.

$10 USD in 0 days
(0 Reviews)
0.0
$20 USD in 1 day
(0 Reviews)
0.0
FanTechTeam

I already write a sample qurey for your work in 20 miniutes. I'm expert at T-SQL and SQL. It's easy to drive a native code in MySQL langue for your case.

$10 USD in 1 day
(0 Reviews)
0.0
amoibean

Okay, here you go: UPDATE `mtotal`.`ARDA` target JOIN ( SELECT `ID_ART`, (@rownumber := @rownumber + 1) AS rownum FROM `mtotal`.`ARDA` CROSS JOIN (SELECT @rownumber := 0) r ORDER B More

$10 USD in 1 day
(0 Reviews)
0.0