SQL Script to Sort Data

€8-30 EUR

Completed

Posted

over 2 years ago

€8-30 EUR

Paid on delivery

Hello, I need an SQL statement that sorts a table that contains id, name and timestamp. The sort should work that way that the names are grouped according to their last timestamp. i.e. all rows of the name with the latest timestamp are shown first with descending timestamp. Then all rows of the name with the second latest timestamp are grouped and shown until all names are grouped. You can imagine this sorting like a sorting of telegram or whatsapp messages ... all messages sorted to their names first, showing all messages of the name with the latest message first. example: RAW DATA ID | name | timestamp ------------------------------------ 01 | ZOE | 1000 02 | TIM | 1002 03 | TIM | 1001 04 | EVE | 1003 05 | GIL | 1004 06 | EVE | 1005 07 | GIL | 1006 08 | EVE | 1007 09 | TIM | 1008 sorts to 09 | TIM | 1008 02 | TIM | 1002 03 | TIM | 1001 08 | EVE | 1007 06 | EVE | 1005 04 | EVE | 1003 07 | GIL | 1006 05 | GIL | 1004 01 | ZOE | 1000 Please state your final quote.

SQL

MySQL

Microsoft SQL Server

Database Administration

SQLite

Project ID: 31557937

About the project

22 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@clementis

Hallo! Kann Dir gerne Dein SQL-Statement schreiben, hätte es in ein paar Minuten fertig, sobald Du einverstanden bist. Wünsche einen schönen Tag! Freundliche Grüße Clemens Schönach

€12 EUR in 1 day

5.0

(1 review)

0.2

22 freelancers are bidding on average €23 EUR for this job

@urmate

Hi I have checked your project description. I have excellent programming and development skills. Contact me with all the details and requirements for your project for further discussion. I will provide you dedicated support and follow-up. Regards Farah Khan

€30 EUR in 1 day

4.9

(462 reviews)

7.3

@Proolancer

Hello Sir, I m an expert in database and I can do the script you need , I invite you to get in touch to discuss details of the project. Best Regards Fouad

€30 EUR in 1 day

4.9

(40 reviews)

6.0

@MaximSky

Hello, I can create this SQL code for sorting your data, I'm SQL expert with 8+ years of experience. You can check my reviews here: https://www.freelancer.com/u/MaximSky Let's discuss details in chat. Regards, Max

€75 EUR in 1 day

5.0

(60 reviews)

5.7

@shashilal

I am indivisual software developer having 9 + years exp in Php,cake,codiegnator and wp,I have completed many web based project in all areas like edu,real estate,insurance,ecommerce. etc.

€24 EUR in 1 day

4.8

(24 reviews)

3.6

@sunitagiriprad

Dear Sir, I am working on SQL server since 15 years. I can write a query of your requirment. Hope to get a chance from you. Thanks and Regards

€25 EUR in 1 day

5.0

(1 review)

2.6

@arturr2

Hi, -Im an expert dba in oracle ocp certification , database developer on sql and plsql , experience from oracle 8.0 version to current 19c, in solaris, linux RHEL and windows environments Experience in oracle developer suite (forms & reports) i can help you , your requirement is very easy to resolve, but i cant bid for a lower price. I'm looking forward to your response

€8 EUR in 1 day

4.9

(4 reviews)

2.8

@matstallmann

Servus, hast du eine Test-Datenbank? Ansonsten erstelle ich eine, folgens der Beschreibung. Ich habe sonst keine weiteren Fragen. Gruß Matthias

€30 EUR in 1 day

4.4

(1 review)

1.4

@m7almasoud

Hello , I am Abdulmohsen from Saudi Arabia, I have five years of experience as a data engineer and working on different databases (relation and NoSQL).

€19 EUR in 7 days

5.0

(2 reviews)

0.4

@xofarew834

Hi, I'm a senior in Website and App Development. I read the job details extremely carefully. I think I can help you to complete your project with my rich knowledge and experience. I'm ready to do it now. Should you require further assistance, feel free to contact me on +918987527635.

€19 EUR in 7 days

0.0

(0 reviews)

0.0

@Nittin

Hi, My Name is Nittin. I have 14 years of experience as a Full stack developer. I worked with big companies(CMM Level 5) and received appreciation from there. I worked on multiple technologies Like: Asp.net, MVC, Sql Server, Angular , .Net Core. Please let me know if we can discuss more on this. Regards Nittin

€15 EUR in 1 day

0.0

(0 reviews)

0.0

@aviralsrivastav3

Hello sir, I am having 4 years of experience with sql. I made many projects using it. I will do my best to provide service as expected by you. I will update daily about the work done on that day. Feel free to inbox me. Thank you

€8 EUR in 1 day

0.0

(0 reviews)

0.0

@Uma171991

Hello sir My name is Umakant Yadav I'm a Full Stack Freelance Developer I am very interested in your project I have 3 years experience in core PHP , Codeigniter and WordPress , webhosting, MYSQL html5 Using Jquery , Ajax. You can see my profile

€10 EUR in 7 days

0.0

(0 reviews)

0.0

@stefancosic24

Hello, I work in MSSQL 3+ years and I think I can help you with it. I also make Power Bi reports via SQL querries and scripts As I understand you need to sort them like last message is always on top ?

€19 EUR in 1 day

0.0

(0 reviews)

0.0

@WyzePal

I have checked your project description. I have excellent programming and development skills. Contact me with all the details and requirements for your project for further discussion. I will provide you dedicated support

€19 EUR in 7 days

0.0

(0 reviews)

0.0

@aifaz

I have more or extensive experience in database development where business logic mostly code in backend SQL with stored procedures and render that through web api, you can contact me with all the details and requirements for your project for further discussion. I will provide you dedicated support if needed.

€20 EUR in 1 day