-
Expert Member
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
-
Junior Member
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
-
Forum Rules