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

€8-30 EUR

Đã hoàn thành

Đã đăng vào

hơn 6 năm trước

€8-30 EUR

Thanh toán khi bàn giao

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

Mã dự án: 15056216

Về dự án

22 đề xuất

Dự án từ xa

Hoạt động 7 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@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 trong 1 ngày

5,0

(5 nhận xét)

2,4

22 freelancer chào giá trung bình €15 EUR cho công việc này

@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 trong 1 ngày

4,8

(112 nhận xét)

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 trong 0 ngày

4,9

(93 nhận xét)

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 trong 1 ngày

5,0

(48 nhận xét)

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 trong 1 ngày

5,0

(25 nhận xét)

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 trong 1 ngày

4,9

(57 nhận xét)

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 trong 1 ngày

4,9

(29 nhận xét)

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 trong 1 ngày

4,7

(8 nhận xét)

4,5

@antonioarana

A proposal has not yet been provided

€8 EUR trong 0 ngày

5,0

(2 nhận xét)

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 trong 1 ngày

0,0

(0 nhận xét)

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 trong 1 ngày

0,0

(0 nhận xét)

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 trong 1 ngày

0,0

(0 nhận xét)

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 trong 1 ngày

0,0

(1 nhận xét)

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 trong 1 ngày

0,0

(0 nhận xét)

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 trong 1 ngày