database , data analytics question..

Posts 2 · Viewed 1919 · Likes 1 · Go to Last Post

ehho2

· Snapshot 0

Like · Likedby · 0

what's the best way to look for a value in a number range and update another column based on that information.

eg, i have a table as such;

fromleft toleft fromright toright leftvalue rightvalue lowrange highrange newvalue

100 116 109 115 apple pineapple

204 240 203 241 bananna peach

requirement: need to fill fields lowrange , highrange and newvalue.

i need to show lowrange highrange and what the value gonna be based on that on newvalue field.

as you see , left fields consists of odd range and right field consists of even range of numbers.

i need to do this for a fairly large sample size like 65k. I can use access, excel or oracle.

please suggest me if you have anyidea.

thank you

Last edited: 06-Feb-21 06:37 PM

pandeyji

· Snapshot 207

Like · Liked by · 1

best solution ...get a nice best weed around ...all the answers will pop up right in front of you like a gorgeously made movie

Please log in to reply to this post

You can also log in using your Facebook

View in Desktop

What people are reading

Visitor from US is reading database , data analytics question..

Visitor from NL is reading Are you an RN, LVN or MA? Favorite has openings for a Disast

Visitor from DE is reading Beef !!

Visitor from US is reading Solve this

Visitor from US is reading webapp dev + marketing

Visitor from US is reading Movie

Visitor from US is reading goat meat in nc

Visitor is reading College Football Action Pick'em Contest 2007

Visitor from SG is reading any link for NZ vs Aus

You might like these other discussions...

IamDJ » Tps8249

TPS Re-registration case still pending ..

· Posts 62 · Viewed 11444 · Likes 10

Sajha Classifieds

Classifieds Summary: Jobs in VA, Room/Apt in MA,VA

· Posts 1 · Viewed 106

NepalNews Sajha

News Summary from Nepal for Wednesday, April 17, 2024

· Posts 1 · Viewed 108

suggestions » Logan

documents for tourist visa

· Posts 4 · Viewed 857

Sajha Classifieds

Classifieds Summary: Jobs in VA, Room/Apt in CO,VA

· Posts 1 · Viewed 198

NepalNews Sajha

News Summary from Nepal for Tuesday, April 16, 2024

· Posts 1 · Viewed 203

Smriti-malla

जाडो, बा र म……

· Posts 1 · Viewed 325 · Likes 1

Sajha Classifieds

Classifieds Summary: Room/Apt in MA

· Posts 1 · Viewed 246

NepalNews Sajha

News Summary from Nepal for Monday, April 15, 2024

· Posts 1 · Viewed 241

trekkinghub

Everest Base Camp Helicopter Tour Cost for 2024 and 2025

· Posts 1 · Viewed 441