Pages

▼
Thursday, November 17, 2022

How to Drop Decimal Places Without Rounding, How to Round a Number to N Decimal Places in Java, Java – How to round double / float value to 2 decimal places, We can use DecimalFormat('0.00') or BigDecimal to round float / double to 2 decimal places.

›
So the problem is rounding number without rounding, for example we have a number 5.789 and if we wa...
Friday, October 28, 2022

MySQL "Group By" and "Order By"

›
A simple solution is to wrap the query into a subselect with the ORDER statement first and applying the GROUP BY ...

Java - Always Name Your Thread Pools - Naming threads and thread-pools of ExecutorService - set name of thread

›
You could supply a ThreadFactory to newSingleThreadScheduledExecutor(ThreadFactory threadFactory). The factory ...

How to convert result table to JSON Array or JSON Object or JSON String in MySQL

›
I'd like to convert result table to JSON Array of Object in MySQL using preferably only plain MySQL commands....

MySQL casting from decimal to string - mysql cast to varchar - mysql convert decimal to string char varchar

›
MySQL - casting from decimal to string select CAST(ROUND(345345345345345345345353453453453454.4345345,6) AS C...
Wednesday, October 26, 2022

Grails on Groovy - join tables using createAlias with additional condition along with sql on condition for additional filter of data

›
We frequently use createAlias to create alias between entity. It actually create connection based on foreign key...