User Profile

Collapse

Profile Sidebar

Collapse
blurryhaddad
blurryhaddad
Last Activity: Aug 16 '07, 04:07 AM
Joined: Aug 16 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • blurryhaddad
    started a topic Using DECODE and LEAST in MySQL
    in MySQL

    Using DECODE and LEAST in MySQL

    hi all..
    i dont understand this sql statement(decod e and least)
    please help me..

    [code=mysql]
    sum(decode(f.co de_category,'3' , nvl(decode(d.fl ag_result,null, decode(least(b. date, :p_startingdate +1)b.date,1),0) ,1),0))[/code]
    please convert this to if and else statement...so that i can understand...th ank you..
    See more | Go to post
    Last edited by Atli; Aug 17 '07, 01:54 PM. Reason: Added code tags
    • blurryhaddad
      started a topic decode and least function
      in Oracle

      decode and least function

      hi all..
      i dont understand this sql statement(decod e and least)
      please help me..

      sum(decode(f.co de_category,'3' , nvl(decode(d.fl ag_result,null, decode(least(b. date,:p_startin gdate+1)b.date, 1),0),1),0))

      please convert this to if and else statement...so that i can understand...th ank you..
      See more | Go to post
      No activity results to display
      Show More
      Working...