Tag: MySQL
How to Display list of databases on a MySQL?
If you want to display the list of databases in a MySQL server, you can use the command ‘show databases’. How to Display list of databases on a MySQL?
How to select Top 5 records from a table in MySQL?
Assume that you have a scenario where you need to retrieve the only the top 5 rows who has the maximum salary from the Employees table. The column name is salary and the table name is Employees. How to select Top 5 records from a table in MySQL? To retrieve the Top 5 employees with maximum salary, order the records by descending order by salary…