How to write an if condition in SQL

Question

I am trying to calculate the query using if condition, I need to show two values as buying and selling.

SELECT
    n.Date as Date,
    n.dp_id as DP_ID,
    cast(n.emp_no as nchar) as emp_no,
    n.holder as HOLDER,
    n.add1 as ADD1,
    n.add2 as ADD2,
    n.add3 as ADD3,
    n.add4 as ADD4,
    n.pin as PIN,
    'emp_table' as rec_type,
    (
    select s.position from emp_table as s
    where s.emp_no = n.emp_no
    and s.dp_id = n.dp_id
    and s.Date < n.Date
    order by s.emp_no,s.Date desc
    limit 0,1
    ) as OPEN_BAL,
    n.position as CLOS_BAL
    FROM emp_table as n
    where true
    and n.Date >= '2013-02-01'
    and n.Date <= '2013-02-8'

----up to this it was working if condition part not working----- 
(select
    open_bal,
    if(open_bal<clos_bal,clos_bal-open_bal,0) as buying,
    if(open_bal>clos_bal,open_bal-clos_bal,0) as selling,
    order by buying desc from emp_table
)

[control-flow-functions](http://dev.mysql.com/doc/refman/5.7/en/control-flow-functions.html) should be your friend — B001ᛦ, Jun 23 '16 at 11:52
Possible duplicate of [Using an IF Statement in a MySQL SELECT query](http://stackoverflow.com/questions/8444570/using-an-if-statement-in-a-mysql-select-query) — Donovan Solms, Jun 23 '16 at 11:55
where do you want to place this query (below the line)? into main query as derived table or as separate one? — mitkosoft, Jun 23 '16 at 11:55

score 0 · Answer 1 · edited Jun 23 '16 at 14:42

0

You can use CASE in place of the if-condition

SELECT   ...,
         CASE WHEN open_bal < clos_bal THEN ID ELSE open_bal END AS ColumnName,
         ...
FROM     emp_table

edited Jun 23 '16 at 14:42

Stacked

6,892
7
57
73

answered Jun 23 '16 at 11:55

Dharmendra

127
12

select n.holder,( CASE WHEN open_balclos_bal,open_bal-clos_bal THEN "Selling" END)) AS status from emp_table still not getting help me to get output? – Grace Peter Jun 23 '16 at 14:05

How to write an if condition in SQL

1 Answers1