1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

List the names and hiredate of all clerks in department 20.

Discussion in 'SQL PL/SQL' started by nallupradeepreddy, Mar 30, 2012.

  1. nallupradeepreddy

    nallupradeepreddy Active Member

    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    65
    1)List the names and hiredate of all clerks in department 20.


    when i am writing query for this it is showing 0 rows updates help me out... plz
     

    Attached Files:

  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    JOB is not 'clerk', it's 'CLERK' (notice the all capitals). Case DOES matter here.
     
    Bharat, vjysoni and nallupradeepreddy like this.