As discussed in the previous post, MySQL is supporting “Window functions” beginning with version 8.0. The window functions enable you to tackle query problems in
Category: RDBMS
Window Functions in MySQL
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
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.
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 