There are three different columns containing dates for various activities user did on the platform. How would you calculate the earliest activity date for the user
AnswerBot
5mo
To calculate the earliest activity date for the user, find the minimum date across all three columns.
Identify the three columns containing dates for various activities
Use a function to find the minimu...read more
Anonymous
author
7mo
Bring all the values in same column through union and then just extract min date
Help your peers!
Add answer anonymously...
Popular interview questions of Business Analyst
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
Follow us
