Skip to content

DatabaseTips.Net – From SQL to database tuning; here you can find it all!

Tag: Coalesce

NOT IN and NULL: a dangerous combination

March 29, 2019 Database Tips Microsoft SQL Server, MySQL, ORACLE, PostgreSQL, SQL

Non-correlated subqueries (where the inner query does not have any column from the outer query tables) are usually implemented using[…]

Read more

Coalesce, NVL, ISNULL, Case, … What should a I use?

January 14, 2019 Database Tips Microsoft Access, Microsoft SQL Server, MySQL, ORACLE, PL/SQL, PostgreSQL, SQL, Transact-SQL functions

There are a lot of options to use when testing for NULL values in SQL. One should use built-in functions[…]

Read more

Search for:

Subscribe to DatabaseTips

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Email Address

Top Posts

Categories

Big data
Blog Presentation
Database schemas
Database tuning
Database users
Error messages
History
Microsoft Access
Microsoft SQL Server
MySQL
ORACLE
PL/SQL
PostgreSQL
Python
RAC
SQL
SQLite
Transact-SQL functions

Tags

Access Archive Backup CASE CAST Coalesce data types DB2 Group by Having initialization ISNULL Joins LAG LEAD Mail MariaDB Microsoft Access; Microsoft SQL Server Missing values MySQL Not Exists NVL NVL2 ORACLE Packages PostgreSQL Privileges Python RAC Recovery Recursive Query Rowid Rownum Row_Number Schemas shutdown split brain SQL SQLite Top N Transaction control Tuning Users Where

WordPress Theme: Poseidon by ThemeZee.