With maybe a few exceptions, all local transit (trams, subways, etc) use between 600 and 800VDC. The control systems are easier and you can apply the line voltage directly to the motors. (BTW, I think the London Underground is the only system that uses a 4 rail system, with separate power and return rails.)
Virtually all currently operting long distance trains use AC, mostly 12-25kv at either 50 or 60 Hz. There are oddballs- in the US is Amtrak's Northeast Corridor is still 11kv 25Hz from WashDC to NYC and to Harrisburg PA, I think parts of SEPTA are, too, and there's at least one private coal hauler in the southwest that's 50KV. IIRC there are a few European systems at 16 2/3 Hz.
In the past there were also 1500 and 3KV DC systems, but AFAIK they've all been taken down long ago. Also, that some systems that were originally 25Hz have been converted to 60.
The next question is usually why 25Hz? When the systems were built, all before 1940, 25Hz was a common frequency for industrial use because the motor commutation was better at lower freqs (motor experts, please correct me), and most railroads generated their own power.
The Indian Railways Fan Club has a nice set of pages that describe their power distribution.
http://www.irfca.org/docs/traction-schematics.html
Me? No, I'm not much of a train fan

.