Suoritettu

SQL Script to Sort Data

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.

Taidot: SQL, MySQL, Microsoft SQL Server, Tietokannan hallinto, SQLite

Näytä lisää: sql script import data, sql script insert data csv, sql script scramble data, hello i need a logo for my site details in private, hello i need a presentation like this original presentation, hello i need to create a logo and a name to put on my clothing brand, hello i need urgent typist you just have to write in notepad from image i, Hello! I need a logo , Hello i need 100$ in NETELLER, i am ready to pay here 160$ in advance !URGENT, hello, i need, Hello i need 90Euro , Hello i need, Hello. I need to come up with a cover design children\ s books 20 pages., Hello, i need 90$ to my skrill ac.because i can\ t withdrall my funds more then 10 days from here, i\ m ready to pay here 155$ f, Hello, i need 90$ to my skrill , Do some data entry, I need you to fill in a spreadsheet with data., HELLO,I NEED A LITTLE PROJECT DONE REAL FAST AND WILL NEED A GOOD CODER TO DO THAT FOR ME.IF YOURE GOOD WITH PYTHON YOU ALSO WEL, BIDS/ENTRIES STARTED PRICE (INR) Odoo Accounting data migration I need an experienced Odoo implementer to help me migrate my , how much data do i need for home internet

Tietoa työnantajasta:
( 10 arvostelua ) Bremen, Germany

Projektin tunnus: #31557937

Myönnetty käyttäjälle:

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 1 päivässä
(1 arvostelu)
0.3

23 freelanceria on tarjonnut keskimäärin €23 tähän työhön

(79 arvostelua)
7.5
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 s Lisää

€30 EUR 1 päivässä
(416 arvostelua)
7.2
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 1 päivässä
(34 arvostelua)
5.9
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, Ma Lisää

€75 EUR 1 päivässä
(51 arvostelua)
5.6
(23 arvostelua)
4.4
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 1 päivässä
(24 arvostelua)
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 1 päivässä
(1 arvostelu)
2.7
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 develop Lisää

€8 EUR 1 päivässä
(1 arvostelu)
2.0
(3 arvostelua)
1.7
matstallmann

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

€30 EUR 1 päivässä
(1 arvostelu)
1.5
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 req Lisää

€19 EUR 7 päivässä
(0 arvostelua)
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 Lisää

€15 EUR 1 päivässä
(0 arvostelua)
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. Lisää

€8 EUR 1 päivässä
(0 arvostelua)
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 Lisää

€10 EUR 7 päivässä
(0 arvostelua)
0.0
seekerscloud

Sir, We are software company Our goal at Seekers Cloud is to challenge customers' preconceptions with our own ideas by offering cutting-edge technology. We create all of our products to provide something that our custo Lisää

€20 EUR 1 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
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 suppo Lisää

€19 EUR 7 päivässä
(0 arvostelua)
0.0
thakursanjay659

Hey, I read your job details and I can do this work exactly as you wanted and have all the potential to provide you quality as well as the quick work for which you looking for. I can start working on your project righ Lisää

€25 EUR 1 päivässä
(0 arvostelua)
0.0
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 7 päivässä
(0 arvostelua)
0.0
harshaiitg97

Hi, I am an experienced Data Engineer with good knowledge of SQL. I read the project description carefully and it seems like an easy task. Let's connect and discuss more. Do check out my Linkedin profile to know more Lisää

€15 EUR 1 päivässä
(0 arvostelua)
0.0