Sql, Sql Queries, Big Data, Data Analytics, Data Science.
analytical function on SQL, like, ROW_NUMBER() RANK() DENSE_RANK() FIRST_VALUE() LAST_VALUE() LAG() LEAD() NTILE() PERCENT_RANK() I hope this article make it easy to understand all the Analytical Functions. In the next article, i will discuss about each of these analytical functions. oh wait! Part