Find Jobs
Hire Freelancers

Build simple SQL Query

$10-30 USD

In Progress
Posted about 6 years ago

$10-30 USD

Paid on delivery
I need some help builing an UPDATE sentence which changes some contents of the rows, based on another row. I want to set Property2 to 1800 from 2 rows which are similar to ID 2 (Sam), being similar means having same Property1. In this case I would change it for ID2 (Sam) and ID4(Jay), since ID1 already is 1800, ID3 have different property, and ID5 could be changed, however I already changed 2 rows. ID....Name....Property1....Property2.... 1.....Bob........0...........1800....... 2.....Sam........0.............0........ 3.....Ted........2.............0........ 4.....Jay........0.............0........ 5.....Eli........0.............0........ The result desired is this one: ID....Name....Property1....Property2.... 1.....Bob........0...........1800....... 2.....Sam........0...........1800....... 3.....Ted........2.............0........ 4.....Jay........0...........1800....... 5.....Eli........0.............0........ I was thinking something like this: UPDATE table SET Property2=1800 WHERE (Something) LIMIT 2. Could you please help me building this query? I need it right now.
Project ID: 16492394

About the project

19 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
19 freelancers are bidding on average $34 USD for this job
User Avatar
//** READY TO START RIGHT AWAY **// More then 5+ years of experience in Development . Also kindly check our profile we have done over 250 project here on freelancer so very much reliable & fit for your project . Kindly initiate chat.
$30 USD in 0 day
4.9 (168 reviews)
7.4
7.4
User Avatar
hello, #2 and #5 seems similar why #5 doesn't have a value of 1800 in the example you wrote? if you explain, I can send you query. ps: ops sorry, since limit is 2 it doesn't have to change. just realized.
$25 USD in 1 day
4.9 (389 reviews)
7.4
7.4
User Avatar
Hello, I can build an update query for you in a short while. I have 10+ years PHP, CSS/HTML, JavaScript and MySQL experience. Please send me a message to discuss the details. I am ready to start. Thank you.
$25 USD in 0 day
5.0 (36 reviews)
6.6
6.6
User Avatar
Sir, I am ready to make the query right now. ..........................................................................................
$15 USD in 0 day
4.8 (86 reviews)
6.9
6.9
User Avatar
Hello, there? Greetings. Here is strong experienced MySQL expert. Please contact me to solve it. Thanks
$35 USD in 1 day
5.0 (10 reviews)
6.1
6.1
User Avatar
Hello Hope you are good sir. Sir i'm sure i can build query for you. I have read your requirements so let's start work without wasting any time. Thanks
$15 USD in 1 day
5.0 (46 reviews)
5.4
5.4
User Avatar
Hello dear, I hope this proposal find you well, I saw your job posting online, I would like to request you please have a look into my previous works. I am a full-time freelancer with over 5 years of vast experience in Website Development & UI/UX designing. I can co-ordinate with you as per your timings and trust me together we can complete your projects in an effective manner. so let's have a chat. I am proud to announce my specialty in: Development: WordPress, PHP, HTML5, CSS, Less, Javascript, Jquery, Bootstrap, Responsive frameworks Design: Adobe Photoshop, Adobe Illustrator If my skills and competencies meet your talent crunch in the above-mentioned capacities let us discuss this matter further.  Thank you We have already converted PSD to wordpress kindly please check the links. We have used Bootstrap, HTML , Wordpress, JS, CSS etc for developing it. Please check our past work in Squarespace: please check our past work :
$250 USD in 3 days
5.0 (35 reviews)
3.8
3.8
User Avatar
Hi Good Day to you I have read your project brief. please discuss with us. ready to work right now We also provide a 24/7 customer care service. Looking forward to your consideration
$14 USD in 1 day
5.0 (2 reviews)
0.9
0.9
User Avatar
Give me a chance to fix it. I will never make u feel discouraged.
$16 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 7 years of sql development experience and handles complex projects and database of size 50 Tb. Relevant Skills and Experience We can provide screenshot and query analyzer techniques to help you further
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
You will have to fetch the determinant row and use a condition to set the target row. I am Banji...I can write functions that will do all those... Chat me up and fill me in on more info
$25 USD in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SPAIN
San Sebastian, Spain
5.0
15
Payment method verified
Member since Oct 24, 2008

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.