Find Jobs
Hire Freelancers

Write SQL query

$10-30 USD

Завершено
Опублікований almost 7 years ago

$10-30 USD

Оплачується при отриманні
Select Max Application number from query result when ID number (person) has more than 1 Application and include it in the original query result
ID проекту: 14289404

Про проект

40 пропозицій(-ї)
Дистанційний проект
Активність 7 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
Greetings, I am experience database designer and SQL specialist so can quickly help you with this task. Please invite me to chat to discuss further details of the project. Regards, Konstantin
$25 USD за 1 день
5,0 (7 відгуки(-ів))
3,3
3,3
40 фрілансерів(-и) готові виконати цю роботу у середньому за $20 USD
Аватарка користувача
Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. What you need here is a query that returns the application details along with an extra column which shows the maximum application number for the same person ID. So if this Person Id has only one application, then the extra field will show the same application number, right? This can be done using a sub query for this additional field. Once I have the table structure, I can do it in no time. Thanks Roni
$20 USD за 1 день
5,0 (75 відгуки(-ів))
6,3
6,3
Аватарка користувача
Hello, I am expert in SQL server and I can write any complex query with optimization. I have 6.10+ years of experience and I have worked with high volume database and written complex query to get various type of data and filters. I have worked with Payroll system, POS, GPS tracking system, Auction management, Insurance info management, etc. and in that I have written thousands of query. I can do this job easily for you and can deliver it quickly for you. Please share database table so I can write query for you and can deliver it quickly. Thanks. Best Regards, NH Kariya
$15 USD за 0 день
5,0 (34 відгуки(-ів))
5,8
5,8
Аватарка користувача
Hi there, I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details. Thanks.
$30 USD за 1 день
5,0 (62 відгуки(-ів))
5,2
5,2
Аватарка користувача
I can do this kindly contact with me I will create a single query in just 5$. so contact with me so that I can start my work thanks
$10 USD за 1 день
5,0 (3 відгуки(-ів))
5,3
5,3
Аватарка користувача
`we have expertise in SQL,MySQL,php, DBA, Data processing. Client satisfaction is our main motto for long term relationship.
$25 USD за 1 день
4,9 (20 відгуки(-ів))
5,3
5,3
Аватарка користувача
Hi! I think it will be like this: select id_number, max(application_number) from table group by id_number having count(application_number)>1
$25 USD за 0 день
5,0 (19 відгуки(-ів))
4,3
4,3
Аватарка користувача
Hi I am Oracle Database developer with 7+ years of experience. I can complete the job within 10 mins. Please ping back. I work for TOP MNC> Thank You Regards Rishi
$15 USD за 0 день
4,9 (6 відгуки(-ів))
3,4
3,4
Аватарка користувача
Hello, Sir Weebside Inc. is a professional freelancer service provided to worthy clients like you. We can provide our best developers to provide you High-Quality Product with 100% Delivery Rate, 100% Satisfaction. Having Experts in Java, C / C++ , C# , VB , .NET , SQL, MySQL, and Python Programming Language and Frameworks made us capable to bid here. We can provide any service of any caliber within Hours. CHAT WITH US TO START RIGHT NOW. BEST DEVELOPERS AROUND. WITH HIGHEST QUALITY DELIVERED WITHIN TIME. WITHIN BUDGET. I m software engineer. I have read the description and I would like to work for you. For further details please inbox me. Thank you
$25 USD за 1 день
5,0 (4 відгуки(-ів))
3,0
3,0
Аватарка користувача
MM. Hi, I am a sql developer. can you please share the table structure and let me know which vendor are you using. sql server, oracle, mysql, etc.. Thanks.
$25 USD за 1 день
5,0 (12 відгуки(-ів))
3,1
3,1
Аватарка користувача
I m software engineer. I have read the description and I would like to work for you. For further details please inbox me. Thank you
$30 USD за 1 день
4,4 (2 відгуки(-ів))
2,6
2,6
Аватарка користувача
I am an experienced SQL query developer. I will do your project. Feel free to contact me for further discussion. Regards, Moeen
$10 USD за 1 день
4,6 (2 відгуки(-ів))
1,9
1,9
Аватарка користувача
Dear Employer , we are experts in Microsoft BI stack , SQL Server ,C# , ASP.Net . we work for Microsoft as consultants and this is first time we are entering into the freelancing world. we are good at data entry projects and filling forms or websites. we have expertise in Excel Macros , Excel Dashboards , spread sheets , tables ,excel analysis etc... we are certified from Microsoft in SQL Server , Oracle ,MSBI. we want to make our foot prints so strong in freelancing world and we need a opportunity to prove our self. we have completed 2 projects successfully and looking forward to work with you. Looking forward to hear from you. Please feel free to ping us.
$15 USD за 1 день
5,0 (2 відгуки(-ів))
1,3
1,3
Аватарка користувача
Requirement Shared: ------------------------------- To develop a query for select Max Application number when ID number (person) has more than 1 Application Our skills matching your Job: --------------------------- We are software engineer professionals with C#, .Net, SQL Server database for past 6+ years. We develop windows applications which are rich in logic/ features and data following coding standards and flexibility to accommodate future changes. Who we are: --------------------------- We are ISO 9001:2008 certified software services company with strong commitment to ensure total customer satisfaction by providing high quality software solutions in the areas of enterprise resource planning (ERP ) solutions, Web / windows/ Mobile application with technologies – ASP.Net, C#, MS SQL server, PHP, MYSQL, ANDROID and IOS. We are professionals and we can deliver quality work on time. Looking forward to work with you, Best Regards, Surekha KV.
$10 USD за 1 день
5,0 (1 відгук)
1,0
1,0
Аватарка користувача
A proposal has not yet been provided
$25 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
12 years experience with MySql/PHP multiple projects and jobs. Available to do it now. Let me know. Thanks
$10 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hi , sir I just read your requirement I have good solution for your project I have long and full-stack experience of it. Can we meet and discuss Thanks.
$30 USD за 1 день
5,0 (1 відгук)
0,0
0,0
Аватарка користувача
Dominamos el sql y tenemos experiencia en soluciones similares.
$15 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Give me the table structs and some testing data by script. I'll find the right way to fit your requirement ASAP.
$20 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
HI, I am really interested in this project, I hove good knowledge about sql quey , I have used mysql, oracle, sql server, sqlite, please come on chat to disscuss more about this one; Thank you
$17 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I can make SQL query according your requirement.
$10 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор HONDURAS
Tegucigalpa, Honduras
5,0
27
Спосіб оплати верифіковано
На сайті з бер. 26, 2015

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.