Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    51

    Unanswered: Need help with the query

    I know we have to use group by, having and max in this but still not able to figure out
    Please help

    Write a SQL to query employee table where employees salary between 1000 to 2000 as catogory A and 2000 to 4000 as category B and etc...
    and choose the maximum salary in each category

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I'm not sure I understand what is the expected output. So, if you could explain it using sample Scott's schema and its EMP table, that would be nice.

Posting Permissions

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