In this post, I am sharing a demonstration on how to calculate the Rank in MySQL query. The RANK() available in Microsoft SQL Server and MySQL doesn’t have any default RANK(). You can calculate RANK using an inline query variable for checking the previous value. If previous record matches to the current record, increment your […]
I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.