SqlServerQuestion.java

import java.sql.*;

public class SqlServerQuestion
{	public static void main(String[] args)
	{	String url = "jdbc:sqlserver://localhost;databaseName=WorksOn;TrustServerCertificate=True";	
		String uid = "sa";
		String pw = "todo";
	
		try ( Connection con = DriverManager.getConnection(url, uid, pw);
	              Statement stmt = con.createStatement(); ) 
		{
			String sql = "SELECT D.dno, dname, P.pno, pname, SUM(hours) "+
							" FROM Dept D, Proj P, WorksOn W "+
							" WHERE D.dno = P.dno AND P.pno = W.pno " +
							" GROUP BY D.dno, dname, P.pno, pname " +
							" ORDER BY D.dno ASC, SUM(hours) DESC";

			ResultSet rst = stmt.executeQuery(sql);

			String last = null;
			int count = 0;

			while (rst.next())
			{
				String current = rst.getString(1);
				if (last == null || !last.equals(current))
				{	last = current;
					count = 0;
					System.out.println("\nId: "+current+"  Name: "+rst.getString(2));
					System.out.println("Proj#\tName\tTotal Hours");
				}

				if (count < 1)	// Only want top 1 if change this to 5 would produce top 5
				{	System.out.println(rst.getString(3)+"\t"+rst.getString(4)+"\t"+rst.getInt(5));
					count++;
				}
			}
		}
		catch (SQLException ex)
		{
			System.err.println("SQLException: " + ex);
		}		
	}
}