Find Jobs
Hire Freelancers

MySql query builder / solver

$2-8 USD / hour

Closed
Posted over 6 years ago

$2-8 USD / hour

i have three tables i want help to get most recent record from table C, here is my query giving me first record $query=mysqli_query($con,"SELECT a. * , b . *, c.* FROM empMaster a, PUnit b , department c WHERE [login to view URL] = [login to view URL] AND [login to view URL] = [login to view URL] GROUP BY empid ORDER BY [login to view URL] DESC"
Project ID: 14946763

About the project

34 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
34 freelancers are bidding on average $6 USD/hour for this job
User Avatar
Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so our devs can work on Your project without delay. We have years of working on projects related on any available CMS, from "scratch" with core php and php-frameworks(Yii/Yii2, Laravel, CodeIgniter), JavaScript, jQuery, AJAX, HTML5, CSS3, Bootstrap, javascript-frameworks, 3d desidg, graphic design etc. However, I shall discuss about the requirements and functionalities in details to have a better understanding about time frame and price. We are glad to chat with You and discuss all in details. Contact us and we will reply immediately. Waiting for Your reply! Best regards, Webbook team
$5 USD in 29 days
5.0 (171 reviews)
7.8
7.8
User Avatar
Hi, i would like to work on your task and liked your offer of full time hire, if so i am ready to complete given task on same rate. let me know if you are interested. sagar
$3 USD in 40 days
5.0 (19 reviews)
6.5
6.5
User Avatar
expert codeigniter developer here. i like to complete this sql query solve . let's discuss. ready to start. thanks.
$5 USD in 40 days
5.0 (57 reviews)
6.6
6.6
User Avatar
I am good in Desktop, Mobile and Website building and 5 years development experience. And I am experienced in Desktop and Web development with Microsoft technologies using C#, WPF , UWP, MFC, C++, Java, Python, Android Camera, face detection, alpr, OCR and Wordpress, Shopify, Woocmmerce Website building. I have a working experience in web user controls, master pages, css files using technologies like AJAX Toolkit, JQuery, JavaScript, XML, HTML, JSON, Bootstrap, Angular js and PHP. So that i have also good skills in Web scrap using VBA and (c#, vb). .Net, ASP.Net (MVC) also. When working on a new project, i like to speak with my clients so that i can have a clear understanding of their needs and vision of the project. Thank you in advance for your time and consideration. I look forward working with you soon.
$5 USD in 40 days
4.9 (60 reviews)
6.4
6.4
User Avatar
Hi I can fix your query just message me i can fix it as your requirement. i m expert in web development
$5 USD in 10 days
5.0 (84 reviews)
6.0
6.0
User Avatar
hello nice to meet you. i am very interested in your project i have rich experience for mysql . your project is very easy for me. i can complete your project in a short time. please send your message so that we can discuss about your project.
$5 USD in 40 days
4.9 (40 reviews)
5.7
5.7
User Avatar
Hi, I would like to modify this query to get most recent record from the table c. Please share details. So that we can take things forward. Thanks.
$5 USD in 40 days
4.9 (93 reviews)
5.8
5.8
User Avatar
I have 5 years of experience in SQL and Database Management . Feel free to contact me ........................................
$11 USD in 40 days
4.9 (35 reviews)
4.8
4.8
User Avatar
Hi, I've been working with MySQL in the past 8 years - so would be a pleasure to help you sort your issue here. Can start right now. Thanks, Lia.
$3 USD in 40 days
5.0 (18 reviews)
4.3
4.3
User Avatar
Hi, i am very good at writing SQL queries. i can provide you the query you are looking for - probably within an hour. Lets have a quick chat.
$2 USD in 40 days
5.0 (26 reviews)
4.4
4.4
User Avatar
SELECT * FROM `department` JOIN `empMaster` ON `empMaster`.`dpID` = `department`.`did` JOIN `PUnit` ON `PUnit`.`empLinkID` = `empMaster`.`empid` ORDER BY `department`.`id` DESC LIMIT 1 Replace `id` in the 2nd line from the bottom with whatever shows the record is "the most recent". Sorry if the query doesn't return exactly what you need, had to write without knowing the scheme :)
$3 USD in 1 day
5.0 (3 reviews)
3.9
3.9
User Avatar
hi, i can help you with your project. send me more information about via freelancer.com chat. regards
$3 USD in 40 days
5.0 (7 reviews)
3.8
3.8
User Avatar
Please provide column details of empMaster, Department tables and please let me know recent department record based on employee or else. I will resolve in max 2 hours. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 7 years and 9 months experience in SQL. Please let me know more details and when we will start. Sky pe jikenjd
$8 USD in 0 day
5.0 (20 reviews)
4.0
4.0
User Avatar
Dear Sir, I'm having an experience with SQL queries and I can help with that. As I see your query, there is an issue with GROUP BY. Please contact me, will finish job within minimum time. Thanks, Vibhav
$7 USD in 40 days
5.0 (2 reviews)
2.7
2.7
User Avatar
I can write any query/oracle/mysql/mssql/postgre
$4 USD in 0 day
5.0 (2 reviews)
2.5
2.5
User Avatar
He i am a software engineer i will help you in fixing your sql query. i have a 10+ professional experience.
$8 USD in 10 days
5.0 (1 review)
1.6
1.6
User Avatar
hii i have strong command in database development system. i can do this project. i already develop many database in 3rd normalized form . i wil provide you quality of work. I recently work on Faculty management system of university database. i can show u my work.
$2 USD in 12 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am experienced back end developer having experience in mysql, oracle and postgresql database. Can you provide table structure of all tables?
$5 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am php programmer having 5 years of experience. I have worked on codeignitor, magento and prestashop . I am ready to work.
$4 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Over the last few years, I've mainly built web sites/utilities from the ground up, which has required me to hone a variety of skills, including MySQL programming. I know how to keep a table optimized when there are millions of rows, and can easily help you with your query/queries.
$8 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Watford, United Kingdom
5.0
42
Payment method verified
Member since Aug 17, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.