Find Jobs
Hire Freelancers

Write SQL query

$10-30 USD

Completed
Posted almost 7 years ago

$10-30 USD

Paid on delivery
Select Max Application number from query result when ID number (person) has more than 1 Application and include it in the original query result
Project ID: 14289404

About the project

40 proposals
Remote project
Active 7 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
Awarded to:
User Avatar
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 in 1 day
5.0 (7 reviews)
3.3
3.3
40 freelancers are bidding on average $20 USD for this job
User Avatar
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 in 1 day
5.0 (75 reviews)
6.3
6.3
User Avatar
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 in 0 day
5.0 (34 reviews)
5.8
5.8
User Avatar
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 in 1 day
5.0 (62 reviews)
5.2
5.2
User Avatar
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 in 1 day
5.0 (3 reviews)
5.3
5.3
User Avatar
`we have expertise in SQL,MySQL,php, DBA, Data processing. Client satisfaction is our main motto for long term relationship.
$25 USD in 1 day
4.9 (20 reviews)
5.3
5.3
User Avatar
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 in 0 day
5.0 (19 reviews)
4.3
4.3
User Avatar
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 in 0 day
4.9 (6 reviews)
3.4
3.4
User Avatar
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 in 1 day
5.0 (4 reviews)
3.0
3.0
User Avatar
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 in 1 day
5.0 (12 reviews)
3.1
3.1
User Avatar
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 in 1 day
4.4 (2 reviews)
2.6
2.6
User Avatar
I am an experienced SQL query developer. I will do your project. Feel free to contact me for further discussion. Regards, Moeen
$10 USD in 1 day
4.6 (2 reviews)
1.9
1.9
User Avatar
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 in 1 day
5.0 (2 reviews)
1.3
1.3
User Avatar
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 in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
12 years experience with MySql/PHP multiple projects and jobs. Available to do it now. Let me know. Thanks
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
Dominamos el sql y tenemos experiencia en soluciones similares.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Give me the table structs and some testing data by script. I'll find the right way to fit your requirement ASAP.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can make SQL query according your requirement.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of HONDURAS
Tegucigalpa, Honduras
5.0
27
Payment method verified
Member since Mar 26, 2015

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.