Completed

Build simple SQL Query

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.

Skills: MySQL, SQL

See more: create a sql database and create a simple but good looking website where i can access and query the database, create simple sql query, build simple sql database, sql queries for dummies, how to run sql query, basic sql queries pdf, sql tutorial, complex sql query examples, sql query examples from multiple tables, sql query examples with answers, sql query examples, mysql, sql, sql query insert data child table, sql command query parent table mysql, simple sql table web frontends, sql server query rijndael aes net, creloaded sql search query, sql tree query child, sql server query tree parent

About the Employer:
( 13 reviews ) San Sebastian, Spain

Project ID: #16492394

Awarded to:

havar2018

Hello, there Having a long and vast experiences in database administration and developing, I can write whatever kind of SQL queries of complexities. Let me do this for review only. You will receive the right result More

$10 USD in 1 day
(2 Reviews)
0.0

22 freelancers are bidding on average $31 for this job

syncwellpvt

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 i More

$250 USD in 3 days
(7 Reviews)
0.0
alysaafan

Hello sir i can do it and my working hours are good for your time zone ! and i have worked with a lot of projects check my portfolio [login to view URL] [login to view URL] [login to view URL]

$18 USD in 1 day
(4 Reviews)
0.0
uabdulaleem

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)
0.0
Banjella

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
(1 Review)
0.0
$15 USD in 1 day
(0 Reviews)
0.0
vw8000414vw

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 Reviews)
0.0
MeghaGFreelancer

Give me a chance to fix it. I will never make u feel discouraged.

$16 USD in 1 day
(0 Reviews)
0.0
exaltedsol

Hi from [login to view URL], Thanks for sparing time on my bid, please check some working projects have Design Responsive-- [login to view URL] [login to view URL] http:/ More

$14 USD in 0 days
(62 Reviews)
0.0
webmuch

Dear Sir, I am Aayush Shastri on behalf of Webmuch Software Private Limited. Webmuch Software is a SaaS focussed software development start-up working intensively to release business intelligence apps over the cl More

$28 USD in 1 day
(0 Reviews)
0.0
sandip101

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
(2 Reviews)
0.0
uhjk

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
(269 Reviews)
0.0
Brijrajs76

i have more than 5 years of experience in wordpress php mysql with responsive design and also have expertise in angular and node and ionic also [login to view URL] [login to view URL] http://www.staples. More

$25 USD in 1 day
(15 Reviews)
0.0
WebInfoSolutions

Sir, I am ready to make the query right now. ..........................................................................................

$15 USD in 0 days
(71 Reviews)
0.0
hamidejaz024

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
(21 Reviews)
0.0
sunnysmile911

Hello, there? Greetings. Here is strong experienced MySQL expert. Please contact me to solve it. Thanks

$35 USD in 1 day
(7 Reviews)
0.0
efforcoder

Hi, sir. Thanks for reviewing my proposal. I have seen your project carefully. I am good at SQL. I am sure I can do your work. Plz contact me. Thanks.

$15 USD in 1 day
(8 Reviews)
0.0
riteshjain009

//** 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 . More

$30 USD in 0 days
(115 Reviews)
0.0
profydev

hi i can create below given query. i can start work right now and will finish within an [login to view URL] me message for start [login to view URL] you.

$25 USD in 0 days
(2 Reviews)
0.0
denizb16

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 days
(18 Reviews)
0.0
DnyaneshwerK24

We can start immediately, Dear Hiring Manager, Hope you are doing well I have gone through your project description i can do that you mentioned in description We have huge experience of website design, mobile app More

$25 USD in 1 day
(5 Reviews)
0.0