Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. how do i get top 3 salaries among department, which is represented by employee with lowest 3 salaries (total 9 rows)

how do i get top 3 salaries among department, which is represented by employee with lowest 3 salaries (total 9 rows)

Scheduled Pinned Locked Moved Database
question
4 Posts 4 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • H Offline
    H Offline
    HughJarce99
    wrote on last edited by
    #1

    how do i get top 3 salaries among department, which is represented by employee with lowest 3 salaries (total 9 rows) please reply.

    L D H 3 Replies Last reply
    0
    • H HughJarce99

      how do i get top 3 salaries among department, which is represented by employee with lowest 3 salaries (total 9 rows) please reply.

      L Offline
      L Offline
      loyal ginger
      wrote on last edited by
      #2

      Please rephrase your question or give some sample records as an example. It's hard to figure out what you really want.

      1 Reply Last reply
      0
      • H HughJarce99

        how do i get top 3 salaries among department, which is represented by employee with lowest 3 salaries (total 9 rows) please reply.

        D Offline
        D Offline
        decipher12345
        wrote on last edited by
        #3

        Please explain ur question. Its not clear for me. Can u come up with any example?

        abhi

        1 Reply Last reply
        0
        • H HughJarce99

          how do i get top 3 salaries among department, which is represented by employee with lowest 3 salaries (total 9 rows) please reply.

          H Offline
          H Offline
          Hiren solanki
          wrote on last edited by
          #4

          It needs kind of presentation that what's your data and what you want as a final output. Furthermore AFA I understood the problem I think you need to apply groupby in SQL and then after sort top 3 records among the retrieved result set. further sample data can make me more clear regarding.

          Regards, Hiren. be good(Help people in CP),do good(Vote if one finds helpful) all will happen good, In case happens bad(You are getting downvote for your best try to help OP) it will be good for later after(Countered with more points by humble member). - Gita sar in context of CP. -So Guys don't care about downvote believe in you.

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups