Computer

posted by .

An employee at xyz Recruiters would like to query the Recruiter table. She has created a query and entered the fields she wants to display in the result in the design grid. Now, she enters the criteria.

3. What would the employee enter in the Criteria row of the Start Date field to find all recruiters who started after January 1, 2005?

4. What would the employee enter in the Criteria row for the Comment field to find all recruiters who have previous experience as a hospital administrator?

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. English

    anyone know where my other question went regarding the mythology sources?
  2. written communication

    I need a example on how to write a Persuasive message and a negative message. Marie or Ann or whoever, http://www.jiskha.com/search/search.cgi?
  3. Computer

    Acess An employee at xyz Recruiters would like to add some additional fields to the Client table. He needs to add fields that will store the Web page for a client as well as whether or not the client participates in a preferred client …
  4. computer science

    If all the hub and authority scores are initialized to 1, what is the hub/authority score of a node after one iteration?
  5. Database Design (SQL)

    I ned help creating a query that shows the number of days left before the end of the term. I need the following functions to accomplish this: CONCAT, DAYOFYEAR, NOW. So far I have this for my query: SELECT CONCAT('There are ',DAYOFYEAR(NOW()),' …
  6. Database Design (SQL)

    I need help creating a query that shows the number of days left before the end of the term. I need the following functions to accomplish this: CONCAT, DAYOFYEAR, NOW. So far I have this for my query: SELECT CONCAT('There are ',DAYOFYEAR(NOW()),' …
  7. programming

    1.Write a query to display the names of the employees that do not have any department_id. 2. Write a query to display the names, salary and job_id of employees in department_id 40, 60 and 80. Display the name as a single column and …
  8. programing

    3.Write a query to display the annual salary of all employees in department_id 20. Display the names in increasing order or salary. 4.Write a query to display the average salary of employees. Label the column as ' Average Salary. 5.Write …
  9. programing

    5.Write a query to display the details of employees in the shipping' department who were hired after '01-JAN 1990' note that the query must use a join. 6.Write a query to display all unique department_id's in the employees table. 7.Write …
  10. computer programming

    Design the logic for a program that allows a user to enter any amount of numbers up to 10 or until a sentinal value of -1 is entered. Then the program displays the count of the numbers entered and numeric average of the numbers (not …

More Similar Questions