Difference between SQL DELETE and TRUNCATE. What is DROP table?
DELETE, TRUNCATE and DROP commands are 3 SQL commands used to clean data; which can be used based on our requirements; Below is small comparative […]
Month: November 2021
String indexing in SQL and way to extract domain names from email repository
CHARACTER POSITIONING IN SQL: In SQL databases each character in string are having a location index starting from 1 from left side of the string; […]
Phases of data analysis
It is very much important to have a framework and to know scope of work before starting analysis. below are the phases or framework that […]
Number approximation in SQL – round, ceil and floor functions
Approximating and standardizing the numbers is one of the common data cleaning requirement before data analytics. In this blog we will discuss 3 useful functions […]