Results 1 to 3 of 3

Thread: sql query help

  1. #1
    Join Date
    Feb 2008

    Unanswered: sql query help


    Department(DeptNum, Descrip, Instname, DeptName, State, Postcode)

    Academic(AcNum, DeptNum, FamName, GiveName, Initials, Title)


    Which departments have the largest number of academics? Return the DeptNum, Instname, DeptName of
    these departments and their total number of academics. You must use ANY or ALL.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >You must use ANY or ALL.
    Enjoy what ever works best for you.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2008
    I can do it without using any or all operator.

    select * from(
    select deptnum,instname,deptname,count(*) "total number of academics"
    from department natural join academic
    group by deptnum,instname,deptname
    order by count(*) desc)
    where rownum<2

    How can I modify it to use any or all operator

Posting Permissions

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