Create an SQL statement for sorting data from one SQLite3 Table

€8-30 EUR

İptal edildi

İlan edilme:

2 yıldan fazla önce

€8-30 EUR

Teslimde ödenir

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.

SQL

MySQL

Microsoft SQL Server

Database Administration

SQLite

Proje No: 31505427

Proje hakkında

16 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 3 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

Seçilen:

@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 1 gün içinde

5,0

(1 değerlendirme)

1,0

16 freelancer bu proje için ortalama €21 EUR teklif veriyor

@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 and complete in a short time. Please send your message so that we can discuss about your project.

€19 EUR 1 gün içinde

4,7

(80 değerlendirme)

5,2

@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 you can see that I do not have any ratings/testimonials to show you. I can finish your sort problem in 20 mins Please review my profile if you have a second. I will do my best. Thanks for visiting my proposal. Best Regards.

€20 EUR 7 gün içinde

5,0

(4 değerlendirme)

3,8

@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 7 gün içinde

5,0

(5 değerlendirme)

3,7

@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 Wordpress, Shopify, Laravel, Joomla and web design. Building user-friendly websites and applications is truly a passion of mine and I am confident I would be an excellent addition to you. My Skills: - Laravel, Yii, Joomla, Wordpress, Shopify - HTML5, CSS, Javascript, JQuery - MySQL, Sqlite, MSSQL, MongoDB - SEO and API Integration I'll do my best for you and provide you satisfied results in a short time. I hope we will discuss more details about your project. Looking forward to your reply. Best Regards...

€30 EUR 1 gün içinde

4,7

(5 değerlendirme)

3,6

@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 7 gün içinde

5,0

(3 değerlendirme)

3,1

@Bsram88

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

€20 EUR 1 gün içinde

5,0

(1 değerlendirme)

2,1

@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 1 gün içinde

5,0

(1 değerlendirme)

0,9

@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 like offer my development services for the job posted as i believe my skills completely match your requirements. I am a India based web developer designer / graphic designer and have 10+ year's of hands-on experience in efficiently coding websites and applications using modern shopify, PHP, MySQL, WordPress, Magento / Laravel , WooCommerce, Custom WordPress Plugins and Themes Development, Modifying WordPress Core, WordPress Hooks, Shortcodes, Metadata, Custom Post Types, and Taxonomies, etc I am available 24 hours support. I am available for the weekend also. If you are looking for website design and development I am the right person for you. I just have few questions for the project. Please chat so we can discuss more

€25 EUR 1 gün içinde

0,0

(0 değerlendirme)

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 1 gün içinde

0,0

(0 değerlendirme)

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 more chat. thanks

€15 EUR 7 gün içinde

0,0

(0 değerlendirme)

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 2 gün içinde