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

Ukończony
Opublikowano ponad 2 lata temu

$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.
Identyfikator projektu: 32723342

Informację o projekcie

23 ofert
Zdalny projekt
Aktywny 2 lata temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
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 w 1 dzień
5,0 (11 opinii)
3,9
3,9
23 freelancerzy składają oferty o średniej wysokości $21 USD/godz. dla tej pracy
Awatar Użytkownika
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 w 5 dni
4,7 (225 opinii)
8,6
8,6
Awatar Użytkownika
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 w 10 dni
4,9 (249 opinii)
8,0
8,0
Awatar Użytkownika
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 w 10 dni
4,9 (153 opinii)
6,9
6,9
Awatar Użytkownika
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 w 40 dni
5,0 (8 opinii)
5,8
5,8
Awatar Użytkownika
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 w 40 dni
4,8 (11 opinii)
5,9
5,9
Awatar Użytkownika
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 w 40 dni
5,0 (25 opinii)
5,8
5,8
Awatar Użytkownika
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 w 40 dni
5,0 (6 opinii)
5,4
5,4
Awatar Użytkownika
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 w 40 dni
4,4 (57 opinii)
6,0
6,0
Awatar Użytkownika
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 w 40 dni
5,0 (4 opinii)
4,3
4,3
Awatar Użytkownika
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 w 40 dni
4,9 (4 opinii)
4,5
4,5
Awatar Użytkownika
Hello Dear Fellow, I would do it. thank you Wram regards
$20 USD w 3 dni
2,5 (6 opinii)
3,8
3,8
Awatar Użytkownika
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 w 1 dzień
3,8 (6 opinii)
2,0
2,0
Awatar Użytkownika
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 w 2 dni
1,2 (5 opinii)
3,2
3,2

O kliencie

Flaga UNITED STATES
Birmingham, United States
5,0
2
Zweryfikowana metoda płatności
Członek od sty 17, 2022

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.