Share on Google+Share on Google+

JDBC : Find Lowest salary

In this tutorial, we are showing how to find record of lowest salary in table employee.

JDBC : Find Lowest salary

In this tutorial, we are showing how to find record of lowest salary in table employee.

MIN() :

MIN() method returns the lowest value of the specified field. So when you want to get lowest value of any numeric field just use MIN method in your query as -

sql = SELECT MIN(salary) FROM employee

Employee Table :  -

Example : In the following example we are displaying record of such employee who has lowest salary among all. For that we are using MIN() function.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

class JDBCMinSalary {
	public static void main(String[] args) {
		System.out.println("Finding Lowest salary Example...");
		Connection conn = null;
		String url = "jdbc:mysql://localhost:3306/";
		String dbName = "employees";
		String driverName = "com.mysql.jdbc.Driver";
		String userName = "root";
		String password = "root";
		Statement statement = null;
		ResultSet rs;
		try {
			conn = DriverManager
					.getConnection(url + dbName, userName, password);
			statement = conn.createStatement();

			String sql = "SELECT * FROM employee WHERE salary=(SELECT MIN(salary) FROM employee)";

			rs = statement.executeQuery(sql);
			while ( {
				int roll = rs.getInt("emp_id");
				String name = rs.getString("name");
				long salary = rs.getLong("salary");

				System.out.println(roll + "\t" + name + "\t" + salary);


		} catch (Exception e) {

Output :

Finding Lowest salary Example...
EmpId	Name	Salary
4	Julu	15000


Posted on: October 10, 2012 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.