Categories play an essential role to classify products in the online store. For eCommerce businesses, categories helps to separate products and categories based on category names. The name of categories should appear on the top of the page. It may even happen that Magento developers only get category ID in the URL. Basically, almost all category name comprises of category ID. Whereas, finding the category name from the category ID is a bit time-consuming and lengthy process. Here, the solution to get category name by category ID using SQL in Magento 2.