Search:

Type: Posts; User: uday_son1983; Keyword(s):

Search: Search took 0.00 seconds.

  1. 12-06-2009

    Thread: Employee and manager name in single query

    by uday_son1983
    Answers
    16
    Views
    30,617

    SQL Re: Employee and manager name in single query

    select a.ename,b.ename from emp a, emp b where a.empno=7698 and b.empno=a.mgr;

    This Query for selecting the particular Emp name & Manager name for the given emp no
  2. 12-06-2009

    Thread: Employee and manager name in single query

    by uday_son1983
    Answers
    16
    Views
    30,617

    SQL Re: Employee and manager name in single query

    select a.ename,b.ename from emp where emp a, emp b where a.empno=b.mgr;

    U can is this query to get the result manager name and emp name in a single query
Results 1 to 2 of 2
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.
GeekInterview
Interact