Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Friday, 1 April 2016

SQL-Exp




This will raise e value to the give power.

     Syntax: exp (value)     

     Ex:
          SQL> select exp(1), exp(2), exp(0), exp(null), exp(-2) from dual;

                        EXP(1)           EXP(2)           EXP(0)  EXP(NULL)    EXP(-2)
   --------            ---------           --------    -------------      ----------

                     2.71828183  7.3890561          1                               .135335283


You May Like                                             
                            SQL Abs
                            SQL Sign
                            SQL Sqrt
                            SQL Mod
                            SQL NVL
                            SQL NVL2
                            SQL Power                           
                            SQL Ln
                            SQL Log
                            SQL CEIL
                            SQL Floor
                            SQL Round
                            SQL Trunc
                            SQL Bitand
                            SQL Greatest
                            SQL Least
                            SQL Coalesce

Share this article :

1 comments:

  1. NayHoh,


    What a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this.

    I am using SQL server 2014 standard edition.
    I am using Drill Through action to display a detail report for my cube data, which is working fine. Only issue I see is when I drill through year and quarter it displays data for months in a haphazard manner instead of sorted by month. Ho do I set it to sort by month, and Item Number (which is a fact dimension for this measure) within month






    Once again thanks for your tutorial.


    Cheers,

    ReplyDelete