Results 1 to 2 of 2

Thread: Tip of the day

  1. #1
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Tip of the day

    NULLs are considered to be larger than any other value. By default order by is given the NULL values appear in the end . We can change this order using NULLS FIRST or NULLS LAST.

    Ex:- SELECT *
    FROM emp
    ORDER BY comm NULLS LAST

    SELECT *
    FROM emp
    ORDER BY comm NULLS FIRST


  2. #2
    Junior Member
    Join Date
    Jan 2008
    Answers
    1

    Re: Tip of the day

    that tip about NULL was really an usefull one... Thanx for its author...


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact