Results 1 to 4 of 4

Thread: SQL query

  1. #1
    Contributing Member
    Join Date
    Jan 2007
    Answers
    48

    SQL query

    Select common job from dept 10, 20,30.
    Default Table emp and dept


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: SQL query

    can you please specify exactly what is the output you are expecting.
    so that i can suggest you accordingly.


  3. #3
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: SQL query

    you can try this

    Code:
    select distinct(job) from emp where deptno in(10,20,30);



  4. #4
    Junior Member
    Join Date
    Aug 2007
    Answers
    1

    Re: SQL query

    hi ppl this is praveen... its really good to get doubts cleared by online.. thanks to geeks talk


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact