Almost a third of school pupils said they have no will to live and almost one in ten said they have attempted suicide.