Results 1 to 3 of 3
  1. #1
    datathinker is offline Member
    Join Date
    Jul 2013
    Location
    Beijing, China
    Posts
    2
    Rep Power
    0

    Default database query(select) question

    Two tables: one is employee(empId, empName, empDept), another is resume(empName, city, work_days).

    To list the employee and count the cities WHERE the employee has worked over one year.

    How to work out a sql to select required data? thanks.

  2. #2
    gimbal2 is offline Just a guy
    Join Date
    Jun 2013
    Location
    Netherlands
    Posts
    3,703
    Rep Power
    5

    Default Re: database query(select) question

    This is an SQL question, not a Java/JDBC question. Try a good book on SQL to learn it.
    "Syntactic sugar causes cancer of the semicolon." -- Alan Perlis

  3. #3
    DarrylBurke's Avatar
    DarrylBurke is offline Member
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,188
    Rep Power
    19

    Default Re: database query(select) question

    Quote Originally Posted by gimbal2 View Post
    This is an SQL question, not a Java/JDBC question.
    Agreed. Closing this thread as off-topic.

    db
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

Similar Threads

  1. Replies: 0
    Last Post: 06-28-2013, 08:17 AM
  2. SQL Query String 'Select'
    By JDev_Beginner in forum New To Java
    Replies: 5
    Last Post: 08-12-2012, 07:16 PM
  3. SELECT FROM WHERE query
    By herfnai in forum JDBC
    Replies: 3
    Last Post: 11-24-2008, 11:04 AM
  4. problem in select query
    By herfnai in forum JDBC
    Replies: 0
    Last Post: 08-17-2008, 11:47 AM
  5. Using a variable in a SELECT FROM WHERE query
    By cplmckenzie in forum JDBC
    Replies: 12
    Last Post: 04-23-2008, 03:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •