Bridgenext interview question

2nd Max sal, duplicate values, analitical functions, date functions, trunc function