Home > IT Answers > Oracle > Equivolent HLOOKUP using SQL
Pg38528
5 pts.
 Equivolent HLOOKUP using SQL
Excel HLOOKUP function, Oracle, Oracle 10g, Oracle SQL, SQL
I am a beginner at SQL... I've come across a situation maybe someone can help me out. I have a table with the following structure: bkt_id am bkt_101 bkt_102 bkt_103 ... bkt_228 bkt_101 $100 $100 $20 $0 bkt_102 $50 $100 $20 $0 ... I want to compare am with the proper bkt_n value using the bkt_id field. In the data above, I want to identify that from record 1 $100 am = $100 bkt_101, and record 2 $50 am <> $20 bkt_102... and so-on. I'm able to download the table to Excel, and perform an HLOOKUP fairly straight-forward. Any thoughts doing it directly in SQL would be greatly appreciated!

Software/Hardware used:
ASKED: July 24, 2009  1:31 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _