Don’t Limit On SQL for Database Computing in Java Development
During Java development, SQL is often used to address the database related computation. However, "Ordered Computation" is very inconvenient to realize by writing SQL statements. For example, according to Contract table, compute the monthly growth rate of contract values for each sales man in a specified period. The result set of SQL follows a weird convention that the result set returned directly