We have Table ABC;
Year_T         Number_Of_Employees_Hired
1995              7
1997              9
1999              2
2000              14
2003              5
2005              6
This table contains data of years and the number of employees hired in a company in the respective year.
Problem is to find out in which years the company did not hire any one.
(Means; we need years, 1996, 1998,2001,2002 and 2004).
Conditions;
We have to use a in-line SQL query only. No stored procedures are allowed. Also, we cannot alter this table or view. FYI, both column types are integers
Submitted by Atif Fasihi
Thursday, May 8, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment