How cn i find employee details,those were join in june month...pls ans it

Answer 1

SELECT *
FROM Employees
WHERE CAST(JoinDate AS DATE) BETWEEN CAST('2016-06-01' AS DATE) AND CAST('2016-06-30' AS DATE)

This of course assumes your table is named "Employees" and your join date column is named "JoinDate". Using this format ensures that a proper match will be made whether your table's date is in standard format or not by forcing all dates involved into the same format.

Answer 2

bro not execute :(

Answer 3

Can you describe what table structure do you have?

Answer 4

I don't have any table structure,u pls write any queries that should be execute only

Answer 5

Hm...
Select * from employees where month = 6
?