Write a SQL Query to find the 2nd or 3rd highest paid employee from an employee table (EMPID, name, salary, Deptname) from every dept using employee t

5 pts.
Tags:
RDBMS
Write a SQL Query to find the 2nd or 3rd highest paid employee from an employee table (EMPID, name, salary, Deptname) from every dept using employee table (EMPID, name, salary, deptname).

 



Software/Hardware used:
sql

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Probably this is an assignment or homework. Have you read your study materials? Have you written sql code for the same? You can use Max() function for this purpose.
    128,810 pointsBadges:
    report
  • ToddN2000
    Ok sounds like a class assignment. Post your code so we can see what you have and let us know what errors you have that make you think your code is not working.  The only way to learn SQL is to keep writing code over and over to reinforce the concepts. 

    124,235 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: