Probíhá

Create an SQL statement for sorting data from one SQLite3 Table

Hello,

I need an SQL statement that sorts a table that contains id, name and timestamp.

The sort should work that way that the data is pre-sorted by timestamp first (descending, newest first), then all entries of a single name are sorted by their first occurence in the pre-sorted result.

RAW DATA

ID | name | timestamp

------------------------------------

01 | TIM | 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

01 | TIM | 1000

08 | EVE | 1007

06 | EVE | 1005

04 | EVE | 1003

07 | GIL | 1006

05 | GIL | 1004

so the names are sorted by descending timestamp with the name blocks starting with the name with the newest occurence.

Dovednosti: SQL, MySQL, Microsoft SQL Server, Správa databází, SQLite

Zobrazit více: create sql server table csv file, create sql data input page, create a sql database and create a simple but good looking website where i can access and query the database, 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, i have 12 scanned images and each one has 30 rows and 15 column i need you will type the data from images to excel, i have 36 statements that i need entered into excel the maximum number of entries per statement is 86 rows and two columns one c, 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 , Hello, I am very interested in the project and I would like to apply to it. I\ m a web developer with 7 years experience in PHP,, 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

O zaměstnavateli:
( 9 recenzí ) Bremen, Germany

Identifikační číslo projektu: #31505427

Uděleno uživateli:

RicardoBetten

Hello, My name is Ricardo i am a FullStack Developer from Portugal. I can quickly solve this query for you. Best regards, Ricardo Bettencourt

€10 EUR za 1 den
(1 recenze)
1.0

17 Freelnceři na tento projekt zveřejňují nabídky v průměru €21

(118 Recenzí)
7.8
AbdulBasitAli045

Hello , How are you? I just saw your project description carefully. I am very interested in your project. I have rich experience in SQL. I am ready to start your project immediately. I am sure I can satisfy you surely Další

€19 EUR za 1 den
(74 Recenzí)
5.1
(21 Recenzí)
4.6
(21 Recenzí)
4.6
claudiofus

Hello, I'm an experienced Italian Web developer with more than 7 years of experience with MySQL and SQLite. I respect the deadlines and the job you are offering. Let me know when you are available to start the project, Další

€25 EUR za 1 den
(1 recenze)
3.7
ashinnd84

Hello there, I am an expert in SQL, SQLite, DBMS. Please, message me to start the work and finish in no time. Thanks Ashish

€19 EUR za 7 dní
(4 Recenzí)
3.7
Emiraza

Hello how are you ? Need to wrote a sql query to sort the data in any form ? Ping me to discuss more on your project

€19 EUR za 7 dní
(2 Recenzí)
3.0
Bsram88

Sure, I can write query and subquery to sort out given order first timestamp and then Shall we discuss Ram

€20 EUR za 1 den
(1 recenze)
2.1
jaibert2

Hello. I'm very happy to bid on your project. I've just read your description and I'm interested in your job. I am a senior PHP developer with 8 years of experience in Web development. I have the strong experiences in Další

€30 EUR za 1 den
(2 Recenzí)
1.6
ahmadndiayee

Hi, I am an experienced Data Engineer with a solid background in SQL. Let's have a call for more details about the project. Regards

€30 EUR za 1 den
(1 recenze)
0.9
rbilozor

Hello sir. This is Roman from Ukraine. I have been in web development for 6+ years and such jobs are my daily practice. Because of COVID-19, I have been in freelancing for now. This is my first time with you and hence Další

€20 EUR za 7 dní
(0 Recenzí)
0.0
bhardwaj202

we will show TIM first - Hi there, I'll design it asap, Professionally & Perfect, Already done many similar Jobs & Projects :) Satisfaction Guaranteed. I am very much interested in the project posted by you and would Další

€25 EUR za 1 den
(0 Recenzí)
0.0
lukep11a

Hi, I can dothis no problem. Got lots of experience using SQL so should be a fairly quick and straightforward job. Regards Luke

€20 EUR za 1 den
(0 Recenzí)
0.0
YounesOMK

hello, i have been working with many kinds of relational databases , hire me and i will get the job done for you

€10 EUR za 2 dní
(0 Recenzí)
0.0
GhazaryanArman

Hello How are you? I have read your details carefully. I am familiar with sql query. I am interested in your project. So, I can help you. I think I can finish your project with in 1 hour. please contact me for mor Další

€15 EUR za 7 dní
(0 Recenzí)
0.0
MohamedTarekf

Hi , I am a python developer with experience in queries. I have done similar projects by MYSQL so it will be easy . I can do it and you have up to 3 modifications or extras.

€14 EUR za 2 dní
(0 Recenzí)
0.0