mySql to get last records of duplicate entries VERY SIMPLE MYSQL QUERY TO FIX -- 2

€8-30 EUR

Selesai

Disiarkan

lebih dari 6 tahun yang lalu

€8-30 EUR

Dibayar semasa penghantaran

mySql to get last records of duplicate entries attached pls find mysql tables. i have a custom view ( attached pls find [login to view URL] containing query ) i need someone to check and fix query to return latest date line when vessel name / month /year are same. more specifically now i get following results for example 1 September 2016 96197892 Pioneer 14/09/2016 72146 25 2 September 2016 96197892 Pioneer 19/09/2016 72151 24 3 September 2016 96197892 Pioneer 19/09/2016 72151 25 4 September 2016 96197892 Pioneer 20/09/2016 72152 22 5 September 2016 96197892 Pioneer 20/09/2016 72152 24 6 September 2016 96197892 Pioneer 20/09/2016 72152 25 and so on i need new query to return September 2016 96197892 Pioneer 20/09/2016 72152 25 October 2016 96197892 Pioneer 20/10/2016 72152 25 and so on I DO NOT OFFER MORE THAN EURO 8 IS VERY SIMPLE FOR SOMEONE THAT KNOWS DO NOT BID MORE WILL NOT GET THE PROJECT .

MySQL

SQL

ID Projek: 15056216

Tentang projek

22 cadangan

Projek jarak jauh

Aktif 7 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@sfmorrison

I can fix your query to return only the latest date like you describe. Relevant Skills and Experience I have been an advanced SQL user for about 10 years writing optimised queries for large data warehouses in a variety of industries. Proposed Milestones €8 EUR - Fix the query to return only the latest date

€8 EUR dalam 1 hari

5.0

(5 ulasan)

2.4

22 pekerja bebas membida secara purata €15 EUR untuk pekerjaan ini

@maxsmith8

Hello, I am available to discuss the project and ready to get started. I have a team of highly skilled professionals, which consists of Designers, Web Developers and App Developers. Relevant Skills and Experience We have enough experiences with WEB and App development for 10+ years. Please visit our profile and see our project reviews https://www.freelancer.com/u/maxsmith8.html Proposed Milestones €8 EUR - COST Looking forward to your response, Lets discuss more over Chat box.

€8 EUR dalam 1 hari

4.8

(112 ulasan)

7.1

@softcarve

Hi, I would like to create a query to get the last record among duplicate entries. Relevant Skills and Experience sql, mysql Proposed Milestones €8 EUR - milestone

€8 EUR dalam 0 hari

4.9

(93 ulasan)

5.8

@shanymathew

Dear Sir, am expert in mysql i can do it 100% perfectly please reply. i will do for euro 8 Relevant Skills and Experience PHP,MYSQL,SQL Proposed Milestones €30 EUR - 1 DAY

€8 EUR dalam 1 hari

5.0

(48 ulasan)

5.1

@BitSDestiny

I am 9+ Years of Experienced Software Developer, successfully completed many projects (please see my reviews), like to work on your project. Relevant Skills and Experience ASP.Net, C#, VB.Net, MVC, WPF, Visual Basic, Excel VBA, MS SQL Server, MYSQL, Oracle, MS Access, Crystal Report, Telerik, Bootstrap, HTML 5, CSS, Java Script is my working domain. Proposed Milestones €50 EUR - Final

€50 EUR dalam 1 hari

5.0

(25 ulasan)

5.3

@danale72

I can fix the query for you. I am able to start right now. Relevant Skills and Experience SQL MySql Proposed Milestones €23 EUR - Acceptance testing finisghed I might need to have connection to you test database. Can you provide that?

€23 EUR dalam 1 hari

4.9

(57 ulasan)

5.4

@jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). Relevant Skills and Experience I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). Proposed Milestones €12 EUR - cost

€8 EUR dalam 1 hari

4.9

(29 ulasan)

4.9

@shizivo

HI, I can make the sql query for you to select the records without any duplicate. You will get the latest (i mean last coming record ) record in every date Please send a message to start this work. Relevant Skills and Experience responsive, fluid, mobile friendly layout using HTML, CSS etc. PHP, MySQL, HTML, CSS, Javascript, Jquery etc. frameworks like Wordpress, Codeigniter, drupal, Magento, Laravel, Joomla etc. Proposed Milestones €12 EUR - Default Regards, Mariya

€12 EUR dalam 1 hari

4.7

(8 ulasan)

4.5

@antonioarana

A proposal has not yet been provided

€8 EUR dalam 0 hari

5.0

(2 ulasan)

2.5

@nevalpatil

Hello SIr, Thank you for checking ID.. I will do this on urgent basis, award me this project and get the desired output... Thanks

€14 EUR dalam 1 hari

0.0

(0 ulasan)

0.0

@bhavnishvw

Lets do it Relevant Skills and Experience Graphic Design, Word, Data Processing, Format & layout, Editing, Publishing, Microsoft Office, Excel, PDF, Illustrations, Logo Design, Brochure Design, Stationery Design, MySQL, SQL Server Proposed Milestones €12 EUR - Can do it now Please provide more of database info

€12 EUR dalam 1 hari

0.0

(0 ulasan)

0.0

@debnathbisal108

Hello sir/ma'm...I won't even take half of the whole day to do it I have been working on MySQL,SQL queries since school days so I assure to complete it within the given time Relevant Skills and Experience MYSQL,SQL Proposed Milestones €8 EUR - I'll do it efficiently is it only one table or more than one table

€8 EUR dalam 1 hari

0.0

(0 ulasan)

0.0

@mshipkaliev

You are right it is a simple task. Relevant Skills and Experience You are right it is a simple task. Proposed Milestones €23 EUR - I

€9 EUR dalam 1 hari

0.0

(1 ulasan)

0.0

@pragank

I have good experience in MySQL query writing and Optimization. I'll give you the perfect optimized query fix within short span of time.

€14 EUR dalam 1 hari

0.0

(0 ulasan)

0.0

@hiremathprabhu15

I am SQL developer having 7 years of exp , for me it would be easy to solve this solution Relevant Skills and Experience SQL SSIS MSBI Proposed Milestones €8 EUR - Worked in couple of Live projects

€8 EUR dalam 1 hari