Share on Google+Share on Google+

JDBC : Find Highest salary

Ads
In this tutorial, we are showing how to find record of highest salary employee.

JDBC : Find Highest salary

In this tutorial, we are showing how to find record of highest salary employee.

MAX() :

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

sql = SELECT MAX(salary) FROM employee

Employee Table :  -

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

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

class JDBCHighestSalary {
	public static void main(String[] args) {
		System.out.println("Finding Highest 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 {
			Class.forName(driverName);
			conn = DriverManager
					.getConnection(url + dbName, userName, password);
			statement = conn.createStatement();

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

			rs = statement.executeQuery(sql);
			System.out.println("EmpId\tName\tSalary");
			System.out.println("----------------------");
			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);

			}

			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

Output :

Finding Highest salary Example...
EmpId	Name	Salary
----------------------
3	Linda	30000

Advertisements

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.

Advertisement