Home Tutorial Java Core JDBC : Find Lowest salary


Share on Google+Share on Google+
JDBC : Find Lowest salary
Posted on: October 10, 2012 at 12:00 AM
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 (rs.next()) {
				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

Related Tags for JDBC : Find Lowest salary:

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.

Posted on: October 10, 2012

Recommend the tutorial

Advertisements Advertisements