Results 1 to 3 of 3

Thread: please answer this query as soon as possible

  1. 10-16-2007, 02:19 AM #1
    ygk
    ygk is offline Registered User
    Join Date
    Oct 2007
    Posts
    2

    please answer this query as soon as possible

    i want maximum of average salaries for each job type among all departments from the default employee table in oracle 9i. if possible in a single query without creating any tables.
    Reply With Quote Reply With Quote
  2. 10-16-2007, 08:48 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Have table schema?
    Reply With Quote Reply With Quote
  3. 10-17-2007, 02:03 AM #3
    ygk
    ygk is offline Registered User
    Join Date
    Oct 2007
    Posts
    2
    the table consists of ename,eno,deptno,job,salary.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules