How to get latest record for the same customer







2) if suppose in the customer id 10 i have 100 records. how to pick the latest,oldest record for that particular id 10. please give me SQL query in teradata







3) second question is how to give the ranks for all records without using rank function