MySQL supports “Window functions” beginning with version 8.0. The window functions enable you to tackle query problems in new, easier, and faster ways. The following
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
SQL Server Interview Questions All in One
This is a collection of previously published articles on this site about SQL Server interview questions and answers. This is for quick reference.
MongoDB – Quick Reference
This is a collection of articles regarding MongoDB that were previously published on this blog. This is for quick reference.
MySQLDump – Complete reference
This is a collection of articles regarding the MySQL utility mysqldump that were previously published on this blog. This is for quick reference.
SQL Server Database Administration
This is a collection of articles about SQL Server database administration that were formerly published on this blog. This is for quick reference.
Get a random number between two given numbers in MySQL
The following example shows how to generate a random number between two provided numbers. This may be useful in situations when the random number must
Big Data & SQL 