select * from tablename where hiredate>='7/1/1981' and hiredate<'10/1/1982'

nice2002 (nice2002)
(#370855@0)
2002-2-16 -05:00

回到话题: There is a table (EMP) of employee's infromation,how to display all employees from the EMP table hired between July and December? Thanks a lot!

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=370855