Cognizant interview question

Index in sql , rank in sql, parameter and variable, aggregator, remove distinct records