There are four different SQL functions in SQL. Each function makes you so confuse when you are very beginner. This post explains SQL functions in Simple manner for beginners as well as for advanced programmers and developers.
Category: SQL Functions
The DECODE scalar function in DB2 SQL helps you handle logic related scenarios. You can also handle NULL values and you can replace NULL values with values as you wish in your end result.
The best and mostly asked SQL query is converting rows into columns. This is a tricky question and it needs little intelligence to write effectively. This SQL query can be written in two steps with SQL functions either CASE or DECODE.
There are 4 functions present in DB2. These are scalar functions, aggregate functions, Table functions and Row functions. Each function has its own purpose and use.