How to retrieve the data from the database in order using Jsp Servlet suppose Category is a table and subcategory is a table. In the category code and Category name are two field. In the second table category code and subCategory name are also two field. first retrieve the categoryname in such a manner Like that.. Firstly Display first Character Name and then display the all category name which have first character of this which is display first with counting the no of user use this category. EXAMPLE:- A APPAREL [486] ARTIST [123] ARTS & CRAFTS [195] AUTOMOBILE [8687] AYURVEDIC & HERBAL PRODUCTS [80] B BICYCLES & RICKSHAWS [24] BUILDING & CONSTRUCTION [12545] BUSINESS SERVICES [600] till Z and so on
| 0 |