Submersible pumps work under water, inside a borewell or an open well, and push water up to the surface. They are chosen by the borewell diameter, the depth (head) and the HP.
Most asked for: borewell submersible pump, openwell submersible pump, 1 HP and 1.5 HP submersible, V4 pump for 4 inch borewell.
Start from the borewell diameter (a V4 pump fits a 4 inch bore), then the total head: the depth to water plus the height to the tank plus pipe losses. Then pick the HP and number of stages that give the flow you need at that head.

