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

€8-30 EUR

Teljesítve

Kiadva ekkor:

több mint 6 évvel ezelőtt

€8-30 EUR

Teljesítéskor fizetve

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

Projektazonosító: 15056216

A projektről

22 ajánlat

Távolról teljesíthető projekt

Aktiválva: 7 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@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 1 napon belül

5,0

(5 értékelés)

2,4

22 szabadúszó adott átlagosan €15 EUR összegű árajánlatot erre a munkára

@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 1 napon belül

4,8

(112 értékelés)

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 0 napon belül

4,9

(93 értékelés)

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 1 napon belül

5,0

(48 értékelés)

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 1 napon belül

5,0

(25 értékelés)

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 1 napon belül

4,9

(57 értékelés)

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 1 napon belül

4,9

(29 értékelés)

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 1 napon belül

4,7

(8 értékelés)

4,5

@antonioarana

A proposal has not yet been provided

€8 EUR 0 napon belül

5,0

(2 értékelés)

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 1 napon belül

0,0

(0 értékelés)

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 1 napon belül

0,0

(0 értékelés)

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 1 napon belül

0,0

(0 értékelés)

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 1 napon belül

0,0

(1 értékelés)

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 1 napon belül

0,0

(0 értékelés)

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 1 napon belül