Only fools use their mouth to speak. A smart man uses his brain, and a wise man uses his heart.- By Jack Ma - Founder of

Find Duplicate Records MySQL Query

Friday, August 22, 2014

Hi All

I know that this is not related Liferay but i came across this useful thing during my development where you can find duplicate record from table and can delete if you need.

SELECT FROM tablename
INNER JOIN (SELECT name FROM tablename
GROUP BY name HAVING count(name) > 1) dup_record ON =

Read Files From Folder

Wednesday, August 20, 2014

Hi All,

You can use below code to read files from specific folders :

public class Test {
     * @param args
public static void listFilesForFolder(File folder) {
        for (File fileEntry : folder.listFiles()) {
            if (fileEntry.isDirectory()) {
            } else {
        System.out.println("Total :" +folder.listFiles().length);