[Show all top banners]

ehho2
Replies to this thread:

More by ehho2
What people are reading
Subscribers
Subscribers
[Total Subscribers 1]

Shitasma
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 database , data analytics question..
[VIEWED 1904 TIMES]
SAVE! for ease of future access.
Posted on 02-06-21 6:27 PM     Reply [Subscribe]
Login in to Rate this Post:     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

 
Posted on 02-07-21 10:43 PM     [Snapshot: 207]     Reply [Subscribe]
Login in to Rate this Post:     1       ?     Liked by
 

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 be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 60 days
Recommended Popular Threads Controvertial Threads
What are your first memories of when Nepal Television Began?
निगुरो थाहा छ ??
Basnet or Basnyat ??
Sajha has turned into MAGATs nest
NRN card pros and cons?
Will MAGA really start shooting people?
मन भित्र को पत्रै पत्र!
Top 10 Anti-vaxxers Who Got Owned by COVID
काेराेना सङ्क्रमणबाट बच्न Immunity बढाउन के के खाने ?How to increase immunity against COVID - 19?
TPS Work Permit/How long your took?
Breathe in. Breathe out.
3 most corrupt politicians in the world
चितवनको होस्टलमा १३ वर्षीया शालिन पोखरेल झुण्डिएको अवस्था - बलात्कार पछि हत्याको शंका - होस्टेलहरु असुरक्षित
शीर्षक जे पनि हुन सक्छ।
Disinformation for profit - scammers cash in on conspiracy theories
someone please tell me TPS is here to stay :(
Nepali doctors future black or white usa ?
Doctors dying suddenly or unexpectedly since the rollout of COVID-19 vaccines
BREAKING: THE LEFT HAS LOST THE SUPREME COURT!
Another Song Playing In My Mind
Nas and The Bokas: Coming to a Night Club near you
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters