i have on my Debian Server MariaDB running.
Now i need a Request to check the days beetween rows.
i have attached a example database.
in the result i want to see as example all dates between the rows who are shorter than 3 days in room 4 ( see attached image )
example result: 4 20201220 20202022
Sysinfo: Ver 10.1.47-MariaDB-0+deb9u1 for debian-linux-gnu on x86_64 (Debian 9.13)
Được trao cho:
Hi, Can you clarify: do you need query to show dates between rows or between columns (from and to) ? This is not the same, but i suspect you need difference between columns (from and to) I recommend myself regards
7 freelancer chào giá trung bình€23 cho công việc này
Hello. I understand you want to query the results which are shorter than 3 days ( from 'date_from' to 'date_to') It's very easy job and I can deliver this in one hour. Kindly give me a message.
Hi, nice to greet you, my name is Alex, I would be interested in working on your project, I have immediate availability I remain attentive to your comments Cheers