Category "recursive-query"

Get a path from manager to an employee in mysql 8

I have a question in term of my database courses, hope that you can help me. The table bellow is an exemple: +------------------------------------+ |ID_EMPLOYEE

SQLite string search in rows then insert string into new rows with values of the same row last column

I want to provide a query to my database that will search if a string exists in Column2(site_id) then put that string in a new table with the value of its befor

how to get no of dates appear between Fromdt to Todt and fetching thouse dates in column

![enter image description here][1] I have table called tbl_monthly_leave in below table i am trying to take dates between fromdt to Todate like (Fromdt , Todate