Find Jobs
Hire Freelancers

Sql query for a mySql database

$10-12 USD

Cerrado
Publicado hace más de 7 años

$10-12 USD

Pagado a la entrega
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.
ID del proyecto: 11822339

Información sobre el proyecto

30 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
30 freelancers están ofertando un promedio de $16 USD por este trabajo
Avatar del usuario
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 en 1 día
5,0 (46 comentarios)
5,9
5,9
Avatar del usuario
Hello, I have extensive experience with MySQL, if you would like to contact me with some further details on the project, we can confirm if it is a match for us and go forward from there. Thank you.
$42 USD en 1 día
5,0 (10 comentarios)
5,7
5,7
Avatar del usuario
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 project. I will complete your project today, LIFETIME error free guarantee and provide 365 days (ONE YEAR) support... ===== Why choose me? ===== 5.0 / 5.0 rating, 100% completion rate, 100% on-time completion, 100% on-budget :) Kindly, check my profile: http://www.freelancer.com/u/BitLabs.html I work smart, hard, and strictly bid only what we can do! No sub-contracting... ever! You will never go wrong choosing me :)
$18 USD en 1 día
5,0 (37 comentarios)
5,9
5,9
Avatar del usuario
Hi Please try me on this. All the best Alexei
$15 USD en 1 día
4,9 (57 comentarios)
5,4
5,4
Avatar del usuario
A proposal has not yet been provided
$10 USD en 0 día
5,0 (15 comentarios)
4,9
4,9
Avatar del usuario
Hi, I am interested in this project and I am available for new job, I know Html, css, Photoshop, MySql, Oracle,Java, J2EE, PHP, and some framework like LARAVEL and CAKEPHP... For more informations please contact me as soon as possible. Thank you so much. Dev OUARKA.
$12 USD en 0 día
5,0 (27 comentarios)
4,3
4,3
Avatar del usuario
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 en 1 día
5,0 (24 comentarios)
4,1
4,1
Avatar del usuario
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# asp.net application development • 2+ years of experience in vb 6.0 Application development • 4+ years of experience in SSIS development • Health Care, Financial, Renewable Energy and E-Commerce domain • 3 projects experience webscraping • Worked on web applications and windows applications using C#, asp.net, MS SQL server and SSIS technologies. • Developed more than 10 web applications, more than 3 windows applications using c#, asp.net and MS SQL server in Financial, Renewable Energy and E-Commerce domain. • Expert in developing complex store procedures, SQL scripts, efficient triggers, required functions, creating indexes and indexed views for performance. Experience in writing complex SQL queries involving multiple tables inner and outer joins • Experience in monitoring SQL Server Performance tuning, identifying dead locks and resolving them in SQL Server 2008 using SQL Profiler • Expert in designing ETL data flows using SSIS; Worked extensively on ETL process using SSIS package from Excel, Flat Files to SQL Server databases • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging
$15 USD en 0 día
4,9 (6 comentarios)
3,7
3,7
Avatar del usuario
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 en 1 día
4,8 (10 comentarios)
3,4
3,4
Avatar del usuario
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 projects and we understand what you want so we are confident that we can do it easily in mention time. We assure you that you will be completely satisfy with our work. And after delivering your project if you feel some issue in understanding the projects then we will teach you free until you understand. If you have any question then feel free to ask. We are here for you. Thank you Demon Developer Team
$12 USD en 0 día
4,3 (16 comentarios)
3,6
3,6
Avatar del usuario
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 waiting for your response.....
$10 USD en 1 día
4,9 (11 comentarios)
2,5
2,5
Avatar del usuario
Hi . I am software developer with 3 years experience. I can do query for You. I read description and saw attached file. Regards, Kilimchuk Igor
$10 USD en 0 día
5,0 (1 comentario)
2,1
2,1
Avatar del usuario
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 architecture, Internet of a thing (IOT) and artificial intelligent. I have experience in the following areas: • Design and development of desktop application using JavaFX and Swing • Design and development of scalable Java application. • Design and development of Javascript web application using MEAN (MongoDB, ExpressJS and AngularJS) technologies. • Design and development of RESTFUL web services with SPRING-MVC and JavaEE. • Database design with SQL (MySQL) and NoSQL(MongoDB) As a certified Java programmer, you can always count on my experience for a quality service delivery on your next project.
$12 USD en 0 día
4,3 (2 comentarios)
2,0
2,0
Avatar del usuario
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're looking for. As I'm new to Freelancer, I am offering a great value so I can build up my profile and portfolio. I'm looking forward to hearing from you!
$20 USD en 1 día
5,0 (2 comentarios)
1,9
1,9
Avatar del usuario
Hi How are you dear , I am interested in your project I have saw you attached file I can do this work right now
$16 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
have worked on multiple projects with sql database, proficient in sql queries, and stored procedures
$16 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i am expert in sql this is simply a work of 5 to 10 minutes hopes so will done it good for you .........
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I already have the SQL ready for your attached example. If interested in my solution, please accept my bid. Thank you.
$12 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I've been analyzing your table Arda. To create the query just to fill the column POSITION in function of RANKING can be easily done; however I'd like to know why would you want to use the UPDATE query (shown in you document file) to change POSITION manually, this would alter the right order that you desire and POSITION wouldn't be in function of RANKING anymore. By the way, I'm Peruvian so I can speak Spanish too. Thanks
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 BY `RANKING` DESC ) source ON target.`ID_ART` = source.`ID_ART` SET `POSITION` = rownum; The idea is to update the target table by joining the table with generated row numbers.
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de PERU
Peru
0,0
0
Miembro desde oct 18, 2016

Verificación del cliente

Otros trabajos de este cliente

Web page in HTML5
$30-40 USD
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.