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 […]
postgres
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; […]