Skip to content

Instantly share code, notes, and snippets.

@rakibdevs

rakibdevs/Roaster & Leave

Created November 2, 2020 11:18
Show Gist options
  • Save rakibdevs/500def2c25f9cf017b190546c7102c03 to your computer and use it in GitHub Desktop.
Save rakibdevs/500def2c25f9cf017b190546c7102c03 to your computer and use it in GitHub Desktop.
Download ZIP
Check duplicate entry sql in holiday roaster and leave table
Raw
Roaster & Leave
SELECT * FROM holiday_roaster where as_id in (select leave_ass_id from hr_leave where leave_from <= '2020-10-30' and leave_to >= '2020-10-30') and date = '2020-10-30'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment