Query for Getting the Top 5 Lowest Values

Asked By amscott 20 points N/A Posted on - 04/07/2012

Hello there techyv experts!

I need someone to help me on this matter.

In my database, Each employees have their salaries computed.

What is the query to display the top 5 employees having the lowest salary?

Thank you so much.

• Status: Open
• Question Views: 1130
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: DB2

Best Answer by Lawren chavez

Go To Solution

Answered By Estillero State 5 points N/A #100504

Query for Getting the Top 5 Lowest Values

Hi Amscott,

Use this SQL query:

USE Employee // your table name

GO

SELECT Emp_FName, Emp_MidName, Emp_LName 

FROM Employee

WHERE Emp_Salary IN (

SELECT TOP 5 MIN(Emp_Salary) // select the bottom  5 employees according to salary

FROM Employee)

GO

I hope it helped.

About Estillero State

Questions
7

Answers
70

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 04/16/2012
• Question Category: DB2

Best Answer

Best Answer

Answered By Lawren chavez 0 points N/A #100506

Query for Getting the Top 5 Lowest Values

 

Hi Amscott,

Assume that your table is Employee: Emp_FName, Emp_MName, Emp_LName, Salary

 

This is a SQL query to display the top 5 employees having the lowest salary:

 

SELECT TOP 5 Emp_FName, Emp_MName, Emp_LName, Salary

FROM Employee

ORDER BY Salary

 

I hope it helpful.

About Lawren chavez

Questions
3

Answers
100

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 12/01/2012
• Question Category: DB2