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

Pages

Tuesday, 11 April 2017

SQL operators



Arithmetic Operators
Relational Operators
Logical Operators
Special Operators
+
=
And
In ,Not In
-
! = or  <>
Or
Between,Not Between
*
> 
Not
Like ,Not Like
/
< 

Is null , Is Not Null

>=



<=




Share this article :

3 comments:

  1. Hi Dayakar,

    Amaze! I have been looking bing for hours because of this and i also in the end think it is in this article! Maybe I recommend you something helps me all the time?

    Kindly assist with the changing time zone,
    i have installed SQL SERVER
    2014, with default settings.
    i am asked to change time to local time. any clue?

    Follow my new blog if you interested in just tag along me in any social media platforms!


    Obrigado,
    Irene Hynes

    ReplyDelete
  2. Hi Dayakar,

    This is indeed great! But I think perhaps you are generally referring SQL operators which is getting unsustainable.

    If FOR EACH ROW clause is specified, then the trigger for each Row affected by the statement. If WHEN clause is specified, the trigger fires according to the returned Boolean value.
    Need help on hierarchy query.

    I have two tables NSL and NSL_COMMENT
    They both are joined using nsl pk column and nsl_comment fk column

    The requirement is that we need to get the first, second, third and so on up to last record using the below mentioned logic.

    Code (SQL):

    nsl.p_k nsl.nk_s_nsl_comm nc.p_k nc.nk_s_nsl_comm

    nc.fk_s_nsl_nsl_comm

    100004805615005 100004805615006 100004805615006 100004805615007 100004805615005
    100004805615005 100004805615006 100004805615007 100004805615008 100004805615005
    100004805615005 100004805615006 100004805615008 100004805615009 100004805615005
    100004805615005 100004805615006 100004805615009 100004805615005 100004805615005

    first record in the child table : nsl.nk_s_nsl_comm from the parent table gives the value to be used in nc.p_k to get first record which is 100004805615006

    Second record in the child table: using first record nc.p_k 100004805615006, we have nc.nk_s_nsl_comm which is 100004805615007, now this becomes nc.p_k for second record

    Third record in the child table : using second record nc.p_k 100004805615007, we have nc.nk_s_nsl_comm which is 100004805615008, now this becomes nc.p_k for third record

    Fourth record in the child table: using third record nc.p_k 100004805615008, we have nc.nk_s_nsl_comm which is 100004805615009, now this becomes nc.p_k for fourth record

    Last record in the child table: nc.fk_s_nsl_nsl_comm = nc.nk_s_nsl_comm gives the last record.

    It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
    Keep up the good work!

    Ciao,
    Anny

    ReplyDelete
  3. Ni Hau,


    Hot! That was HOT! Glued to the #topic your proficiency and style!

    select name,value from v$parameters abc
    minus
    select name,value from v$parameters@test xyz
    and xyz.value >abc.abc

    Can anybody please help me above sql?


    Follow my new blog if you interested in just tag along me in any social media platforms!


    Many Thanks,

    ReplyDelete