Oracle interview question

Coding questions: Pick third highest number from without using loop Write code to print highest repeating character/s in string