rank(), dense_rank(),row_number() and some of their use cases
These are quite useful SQL functions which come handy in many cases while analyzing data. In this blog we will see how those work, we […]
SQL
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 […]
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; […]