Find Jobs
Hire Freelancers

looking for someone who are experienced with my sql query

$10-30 USD

Closed
Posted over 3 years ago

$10-30 USD

Paid on delivery
Hi. developers. I am going to get rows from the table where filed value is greater than specific value(integer). for example select * from table where filed > 10000. but what the problem issue is that the field contains dirty data. As you can see in the attach the fields contains $, comma, k, M, range(from a to b) I am looking for someone who can execute the query from this field to get the rows where the value is greater than specific value . I'll send the table to the right developer. Thank you.
Project ID: 27359584

About the project

36 proposals
Remote project
Active 4 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
36 freelancers are bidding on average $26 USD for this job
User Avatar
Hello, As an expert in MySQL, i can make the correct query to retrieve the required data. I am available to do it right away. Thanks
$22 USD in 1 day
5.0 (281 reviews)
7.7
7.7
User Avatar
Hello, I'm Abu Gosia. I'm interesting in your project very well. We can use replace function during fetching data. I'm good in Website Design, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart, C#, .Net, MVC, Angular.js, ASP.NET. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
$30 USD in 1 day
4.8 (205 reviews)
6.9
6.9
User Avatar
Hi, I have 6 years hands on experience in microsoft sql server developer.I have done this type of work many times with accuracy and efficiently in my job journey.I am very efficient in writing complex T-SQl code,clean the data using SSIS packages and load them in accurate format according to business needs. Consider my services for your project, i will try my best to deliver the desired results according to business needs. Thanks.
$25 USD in 1 day
5.0 (1 review)
6.1
6.1
User Avatar
Hello there, I'm expert in MuSQL query, I can execute your query, I'm a full time freelancer I can start work immediately. Best Regards, Priya
$30 USD in 1 day
5.0 (36 reviews)
5.3
5.3
User Avatar
Hi, hope you are fine. I have seen .png file you have attached. If you want to filter data on where filed > 1000 then field column should be integer but in your case you cannot cast it into integers as there are characters and alphabets in many rows. So the solution to this problem is data cleaning. You have to clean the data first in order to execute the above query. To clean the data we can use regex. I'm Database Engineer and I have faced such types of issues multiple time. Let's connect to discuss in detail. Thanks
$30 USD in 2 days
5.0 (6 reviews)
4.5
4.5
User Avatar
Hi There, I can define complex sql query as per your requirement and you will get desired result. Looking forward to discuss. Thanks
$30 USD in 7 days
4.7 (6 reviews)
4.1
4.1
User Avatar
Hello There , I have 4 years of experience in SQL Querries . i understood your problem with data as you mentioned. i can complete this quickly. Looking forward for your revert. Thanks , Shrushti
$20 USD in 1 day
5.0 (12 reviews)
3.2
3.2
User Avatar
Hello, I can do this for you using php and arrays. The values marked 1.1 milion etc will need a separate function to grab and i believe I have a solution for it. Best regards
$30 USD in 7 days
5.0 (4 reviews)
3.0
3.0
User Avatar
Hi, This is Samadhan, 8+ years of experience in Java/J2EE technologies like C, C++,Core Java, EJB 3.0, SmartGWT ,SpringDAO, MyBatis, JSF,ORACLE,DB2, with excellent technical skills & hands on knowledge in designing & implementation of development processes. I have gone through your requirement and I can execute the query to get the rows where the value is greater than specific value . please share the table. I am sure we will have long term work relationship. I would highly appreciate if you come up with private chat for more discussion. Thanks, Samadhan
$20 USD in 1 day
4.9 (4 reviews)
3.2
3.2
User Avatar
Hi there, I am a computer science grad (Bachelor's degree) and a SQL expert with 3 years of experience. I checked your pic and guarantee you it's gonna be done within the next 24 hours. Let's contact via chat so that I can start work immediately. Wish you the best. Regards, Eslam
$20 USD in 7 days
5.0 (4 reviews)
2.6
2.6
User Avatar
Hello you need to use regex in mysql. Can I help you?
$50 USD in 1 day
5.0 (3 reviews)
2.3
2.3
User Avatar
I have more than 13 years of IT experience with various database technologies. Working Knowledge of MS-SQL,my-sql,postgres,Oracle Databases. Expertise in developing skill , proficient in PL-SQL writing stored procedures, triggers and functions. Worked in build complex query. Built ERD Diagram Database tuning experience. Good written and client interaction skills at all management level. Energetic self-starter and can learn new technology in short time. Tuning query performance and recommending better way to optimize SQL queries and pl-pgsql/T SQL programs Migration experience from Oracle to Postgres, Postgres to MS-SQL. Performed migration till 5 TB of Databases. Having Developing/DBA experience of postgres database size more than 10 TB.
$30 USD in 7 days
4.0 (1 review)
2.4
2.4
User Avatar
Hi, I am from datawarehosuing domain with 7 plus years of experience. Worked on databases like oracle, netezza, teradata and sql server. In work place i face same kind of data given in example and i can help on resolving it
$35 USD in 7 days
5.0 (2 reviews)
2.1
2.1
User Avatar
Software Engineer specializing in Java development. A skilled java developer with proven expertise in using new tools and technical developments to drive improvements throughout a entire software development lifecycle. Skill Highlights Experience Java developer - 02/2016 to Present Angular Frontend developer - 01/2019 to Present Develop project concepts and maintain optimal workflow. Work with senior developer to manage large, complex design projects for corporate clients. Complete detailed programming and development tasks for back-end server code. Carry out quality assurance tests to discover errors and optimize usability.
$18 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I read with interest your posting for this job.I believe that I possess the necessary skills and experience you are seeking and would make a valuable addition to you. As i have worked on different kinds of scripting languages like HTML,CSS,JQuery and Php,Php(Codeigniter) from 4+ years and these are well enough to fulfill your expectation. I would appreciate the opportunity to talk with you to discuss the further requirement. Thanking you in advance for your time,
$67 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Sir,I can complete your project on time and within your budget I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I would love to work on your project I have good knowledge in PHP, Codeigniter, bootstrap, Ajax, JQuery, HTML, CSS. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.
$15 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I am a software engineer, have over 2 years of working experience in IT industry but new in freelancing. I want to let you know that I can fulfill your requirements properly and I'll be able to complete your work in time schedule and I can ensure you that won't make any mistakes. I pride myself on being extremely professional and aim to always deliver a job well before a given deadline. I look forward to work for you and helping you streamline your tasks to improve your requirements. Regards, Pradnya Mestry
$20 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Ita a very small problem I can fix it within a short span of time. I have been working on mysql for the past 3years.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Привіт! Давай допоможу і почищу дані. Може навіть вдасться написати готову функцію для подальшого використання.
$30 USD in 1 day
0.0 (0 reviews)
1.4
1.4
User Avatar
Hello, I have 10+ year experience in Php + postgresql + mysql along with 4 years of DevOps eng. Please share more details so we can connect and will do the needful for your request.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UKRAINE
Poltava, Ukraine
5.0
2
Member since Mar 2, 2020

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.