Find Jobs
Hire Freelancers

MySql query builder / solver

$2-8 USD / hour

Fechado
Publicado há quase 7 anos

$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"
ID do Projeto: 14946763

Sobre o projeto

33 propostas
Projeto remoto
Ativo há 7 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
33 freelancers estão ofertando em média $6 USD/hora for esse trabalho
Avatar do Usuário
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 em 29 dias
5,0 (246 avaliações)
8,3
8,3
Avatar do Usuário
Hi I can fix your query just message me i can fix it as your requirement. i m expert in web development
$5 USD em 10 dias
5,0 (185 avaliações)
6,7
6,7
Avatar do Usuário
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 em 40 dias
5,0 (19 avaliações)
6,5
6,5
Avatar do Usuário
expert codeigniter developer here. i like to complete this sql query solve . let's discuss. ready to start. thanks.
$5 USD em 40 dias
5,0 (62 avaliações)
6,7
6,7
Avatar do Usuário
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 em 40 dias
4,9 (62 avaliações)
6,4
6,4
Avatar do Usuário
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 em 40 dias
4,9 (40 avaliações)
5,7
5,7
Avatar do Usuário
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 em 40 dias
4,9 (93 avaliações)
5,8
5,8
Avatar do Usuário
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 em 40 dias
5,0 (56 avaliações)
5,0
5,0
Avatar do Usuário
I have 5 years of experience in SQL and Database Management . Feel free to contact me ........................................
$11 USD em 40 dias
4,9 (36 avaliações)
4,9
4,9
Avatar do Usuário
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 em 40 dias
5,0 (18 avaliações)
4,3
4,3
Avatar do Usuário
hi, i can help you with your project. send me more information about via freelancer.com chat. regards
$3 USD em 40 dias
5,0 (11 avaliações)
4,5
4,5
Avatar do Usuário
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 em 1 dia
5,0 (3 avaliações)
3,9
3,9
Avatar do Usuário
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 em 0 dia
5,0 (22 avaliações)
4,0
4,0
Avatar do Usuário
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 em 40 dias
5,0 (2 avaliações)
2,7
2,7
Avatar do Usuário
He i am a software engineer i will help you in fixing your sql query. i have a 10+ professional experience.
$8 USD em 10 dias
5,0 (1 avaliação)
1,6
1,6
Avatar do Usuário
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 em 12 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am experienced back end developer having experience in mysql, oracle and postgresql database. Can you provide table structure of all tables?
$5 USD em 0 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am php programmer having 5 years of experience. I have worked on codeignitor, magento and prestashop . I am ready to work.
$4 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am strong in SQL join queries and this project is straight forward. I can get the result in a few minutes
$8 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED KINGDOM
Watford, United Kingdom
5,0
42
Método de pagamento verificado
Membro desde ago. 17, 2013

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.