Having successfully created the table, let us now insert some random records in it to use in examples. You may use the following code snippet to perform the task. In the previous examples, we have straightforwardly considered sales targets without considering the current status of sales targets met by the individual salesperson. NULLIF is a flow control function that takes two arguments and examines if the given arguments are equal or not.
If they are equal, it returns NULL value of data type similar to the first argument otherwise returns the first expression. Here we discuss Introduction, syntax, parameters, and Examples with code implementation. You can also go through our other related articles to learn more —.
Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.
By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Popular Course in this category. Improve this question. Kajbo Kajbo 3 3 gold badges 9 9 silver badges 29 29 bronze badges.
Add a comment. Active Oldest Votes. Improve this answer. Lukasz Szozda Lukasz Szozda k 18 18 gold badges silver badges bronze badges. The first solution checks for NULL. The second checks for a magic value that may or may not occur in the data 'false'. Best practice is to avoid magic values. HABO I agree that we should avoid "magic" values at all cost and first approach is preferred. EzLo EzLo Sign up or log in Sign up using Google.
Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.
0コメント