Definitely RT-PCR is more sensitive, so you can check the level of expression for lower expressed genes. More information you can find in paper for example
Magdalena is right: a well-designed qPCR assay is much more sensitive, so you can detect lower levels of expression and/or use lower RNA input quantities. Depending on the detection reagents and system, a melting curve can be done following the reactions to assess the presence of multiple products. If enough RNA is available, though, and with proper probe selection, a Northern might still provide valuable information on RNA size(s) and multiple spliceforms.