Category: SQL TUTORIAL
Please follow below best practices when you are planning to move the data from the on-premise database to AWS S3 and then to Redshift: Files should be compressed at …
Hello there! Generally, when it comes to practicing SQL queries, we start with an employee table that is a kind of standard set by the Oracle database. What if …
In this post, we discuss what are the things we need to keep in mind while stored procedures in SQL Server when it comes to performance and best practice. …
In this post, we discuss what are the things we need to keep in mind while dealing with datatypes in SQL Server when it comes to performance and best …
In this post, you will learn about the Oracle DUAL table which is a special table used for evaluating expressions or calling functions. Now let’s dig into more on …
In short, the difference between UNION operator and UNION ALL (UNION vs UNION ALL) operator is UNION gives unique results set in the output even though the combined result …
ALL_TAB_COLUMNS and ALL_TAB_COLS are the views in Oracle that describes the columns of the tables, views, and clusters accessible to the current user. The only difference between two views …
DENSE_RANK calculates the rank of a value in a group of values. The return type is NUMBER. If two or more rows tie for a rank, each tied rows …
