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

€8-30 EUR

Finalizat

Data postării:

peste 6 ani în urmă

€8-30 EUR

Plata la predare

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-ul proiectului: 15056216

Despre proiect

22 propuneri

Proiect la distanță

Activ: 7 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@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 în 1 zi

5,0

(5 recenzii)

2,4

22 freelanceri plasează o ofertă medie de €15 EUR pentru proiect

@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 în 1 zi

4,8

(112 recenzii)

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 în 0 zi

4,9

(93 recenzii)

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 în 1 zi

5,0

(48 recenzii)

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 în 1 zi

5,0

(25 recenzii)

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 în 1 zi

4,9

(57 recenzii)

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 în 1 zi

4,9

(29 recenzii)

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 în 1 zi

4,7

(8 recenzii)

4,5

@antonioarana

A proposal has not yet been provided

€8 EUR în 0 zi

5,0

(2 recenzii)

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 în 1 zi

0,0

(0 recenzii)

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 în 1 zi

0,0

(0 recenzii)

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 în 1 zi

0,0

(0 recenzii)

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 în 1 zi

0,0

(1 recenzie)

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 în 1 zi

0,0

(0 recenzii)

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 în 1 zi