Hadoop Hive query to filter employees

Question

I have created a table that has the following columns:

• name
• eid
• salary
• D.O.J (Data of Joining)
• D.O.L (Data of leaving)

Now I want to display the employees who were in the company between 01-01-2018 and 31-11-2018. How to run a query to do this?

Answer 1

select * from tablename where DOJ> '2018-01-01' and DOL< '2018-11-31'