Find Jobs
Hire Freelancers

MySQL ranking based on groups filtered by column value, on two seperate columns, all in the same table

$15-25 USD / hour

已完成
已发布超过 2 年前

$15-25 USD / hour

Have a scoring website that uses a single table, which combines two events and a cumulative total and final rank: 1. Need ranking in "rank" column based on "total" column sorted in ascending order 2. Need ranking in "final rank" column, based on "final total" column sorted in ascending order, since the lowest final total wins. 3. Also need to be able to when 1 of 3 checkboxes are checked, need to be able to insert a letter based on the checkbox. and remove the totals, and places those records at the bottom, after the ranked rows (which is shown as is in my MySQL statement, but I am just unable to do the ranking, and that column replacement together for the single column) attached you will find the MySQL statement.
项目 ID: 32723342

关于此项目

23提案
远程项目
活跃2 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi, I’ve carefully checked your requirements and really interested in this job. I’m full stack web developer . I’m offering best quality and highest performance at lowest price. I’m well versed in PHP ,Laravel React/Redux, Angular JS, Node JS, html/css as well as javascript and jquery. I have much experience in MySQL. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details. Thanks
$40 USD 在1天之内
5.0 (11条评论)
3.9
3.9
23威客以平均价$21 USD/小时来参与此工作竞价
用户头像
Hello Dynamic S.,   We have 20 years of strong experience in PHP, MySQL, as a result, we can successfully complete this project.   Please, review our profile here: https://www.freelancer.com/u/tangramua Here detailed information about our company, our portfolio, and the client's recent reviews.   Also, we wanted to personally discuss questions about your project, which helps us to give you the right estimation.   Best regards, Tangram Canada Inc.  
$25 USD 在5天之内
4.7 (225条评论)
8.6
8.6
用户头像
Can you give sample data in excel or sql file? also can you share the sample out for each point? or lets have a quick call?
$35 USD 在10天之内
4.9 (249条评论)
8.0
8.0
用户头像
Hi sir, I'm an experienced Web Developer working since 2007 as a PHP & MySQL coder. I can surely help you with your project and have it done in a timely manner, with fair prices and high quality work. But before we start, just let me make some important questions: 1. Do you need modifications to your SQL statement as well? or changes are only for the frontend page? 2. Was your website made with a PHP framework like Laravel or core PHP? 3. Do your web pages use any kind of javascript framework? Also can you please provide me your website URL? (so I can take a look and make a proper bid). Best Regards.
$15 USD 在10天之内
4.9 (153条评论)
6.9
6.9
用户头像
I've been working for a database designer for 5 years and experienced realtional databases like mysql, oracle, mssql. I am the one who came up with the idea of MongoDB the document oriented database and also have 3 years experience for data entry. I will do your job perfectly Satisfy customer's requirements perfectly is my objective
$20 USD 在40天之内
5.0 (8条评论)
5.8
5.8
用户头像
Hello. How are you? I have read your description carefully I am a senior developer. So can help you perfect this. If you give me this project I can do within a few hours. I want to discuss more via chat. Thank you!
$25 USD 在40天之内
4.8 (11条评论)
5.9
5.9
用户头像
Hello there, i've been working with MYSQL for over 8 years. Actually mysql doesn't support rank function but we can demostrate that rank function by specifying variable and plus when checking the previous row. Pls share me more your requirement so we can discuss. Waiting for your response if interested. Thank you!!!
$20 USD 在40天之内
5.0 (25条评论)
5.8
5.8
用户头像
I can fix your scoring website's table and other functions with high quality on time. I would like to know the details through the chatting box. Thank you.
$20 USD 在40天之内
5.0 (6条评论)
5.4
5.4
用户头像
Hi There...! Note : I give you 25% off on my all services. So grabs this special limited discount offer. Let’s get to the Project. I came to know that your Looking a developer which have rich knowledge about Sql development .you need expert SQL expert developer for this job . According to your post description, you need the job done very quickly with an affordable budget. Your requirements are fully clear to me and I am applying only because I meet all the requirements that you are looking for. I have been working as a full stack Sql developer for more than 10 years and I know all the ins and outs of Sql development and customization Project should be 100% correct and Complete that will be my first guarantee service in this project. Moreover, I will be available for you for any kind of future edits and customizations. Sometimes my ten years back clients search for me till now only because of my excellent service. I am mostly in love with communication. I like to be in touch with my clients 24/7 so that they can catch me at any time when they need me. I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you. Thanks Sohail jamil
$15 USD 在40天之内
4.4 (57条评论)
6.0
6.0
用户头像
Hello, I am a PHP, Mysql expert. I can get the ranking and update your project related to checkbox. I am very familiar with Sql query, t-sql, trigger and have full experience in php. I can complete your project in a short time. Please reach out to me and get start the work. Hope your kind response. Thank you! Eudis
$20 USD 在40天之内
5.0 (4条评论)
4.3
4.3
用户头像
Hello, I have read your job description carefully. I am a web developer with 10 years of experience in PHP, MySQL, Javascript, HTML, CSS. Also, I have rich experience in MySQL Query. So I am interested in and I am confident in your project. If you give me a chance, I will provide you with the perfect result. I hope you send me a quick message. Regards. Diana
$25 USD 在40天之内
4.9 (4条评论)
4.5
4.5
用户头像
Hello Dear Fellow, I would do it. thank you Wram regards
$20 USD 在3天之内
2.5 (6条评论)
3.8
3.8
用户头像
Innovative and technically-astute software developer with 13+ years of experience in developing full stack applications. I am confident enough to do justice to your task and complete the task timely and fulfill the expectations.
$20 USD 在1天之内
3.8 (6条评论)
2.0
2.0
用户头像
Hi, It is easy, I can do on time. I work online, where you can track progress of your project. I have 6 years of experience in development(websites, web applications, mobile apps, desktop applications, I/UX), using PHP, WordPress, Java, Python, JavaScript, ReactJs, Bootstrap, I can start now, please come to chat, to discuss more.
$15 USD 在2天之内
1.2 (5条评论)
3.2
3.2

关于客户

UNITED STATES的国旗
Birmingham, United States
5.0
2
付款方式已验证
会员自1月 17, 2022起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。