• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 978
  • Last Modified:

query to find the lower values of two columns for sql server

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
2 Solutions
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
Something like the following

Select emp_no, Case When bonus1 < bonus2 Then bonus1 Else bonus2 end
from mytable
try this:
select emp_no, case when bonus1 < bonus2
            then bonus1
            else bonus2 end as lower_of_bonus1_bonus2
  from TableName

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now