Mysql – Return second highest date
I have a sales table, where it shows the information below ID_sale sales_person sale_date 7 50 19/10/2022 6 43 17/9/2022 5 50 15/3/2022 4 43 13/2/2022 2 50 22/1/2022 3 10 05/2/2022 1 12 07/1/2022 and I want to create…