Advertisement

06.13.2008 at 07:03AM PDT, ID: 23482730
[x]
Attachment Details

query to find the lower values of two columns

Asked by ewang1205 in Oracle Database

Tags: oracle

I have the following table columns .  
emp_no, bonus1, bonus2

I like a simple sql to find the lower value of bonus1 and bonus2, so the out_put is:
emp_no, lower_of_bonus1_bonus2
Start Free Trial
[+][-]06.13.2008 at 07:15AM PDT, ID: 21779069

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle Database
Tags: oracle
Sign Up Now!
Solution Provided By: markgeer
Participating Experts: 3
Solution Grade: A
 
 
[+][-]06.13.2008 at 07:17AM PDT, ID: 21779088

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]06.13.2008 at 08:02AM PDT, ID: 21779669

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]06.13.2008 at 08:41AM PDT, ID: 21780078

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628