Tomb of Mughal Emperor Humayun. #humayunstomb #photography #Jorvee #travelphotography #traveller

Tomb of Mughal Emperor Humayun. #humayunstomb #photography #Jorvee #travelphotography #traveller via Instagram

Humayun's Tomb, Nizamuddin, New Delhi, India 🇮🇳 #humayunstomb #Jorvee

Humayun's Tomb, Nizamuddin, New Delhi, India 🇮🇳 #humayunstomb #Jorvee via Instagram

Bu Haleema gateway, open door for Mosque and Sarai of Arab. #dilli #heritage #humayunstomb #gateway #tomb #mughal #building #architecture #photography #Jorvee

Bu Haleema gateway, open door for Mosque and Sarai of Arab. #dilli #heritage #humayunstomb #gateway #tomb #mughal #building #architecture #photography #Jorvee via Instagram

Jamali Kamali Mosque, Mehrauli #heritage #city #delhi #jamali #kamali #mosque #masjid #photography by #Jorvee

Jamali Kamali Mosque, Mehrauli #heritage #city #delhi #jamali #kamali #mosque #masjid #photography by #Jorvee via Instagram

The one who bows down to Allah, can standup to anything.

The one who bows down to Allah, can standup to anything. via Instagram

Remove duplicate entries from ArrayList or List without using collection

Remove duplicate entries from ArrayList or List without using collection.

package testMavProject;

import java.util.ArrayList;

public class removeDuplicate {

public static void main(String[] args) {

// Create a ArrayList type of Integer or other datatype.

ArrayList<Integer> aList=new ArrayList<Integer>();

aList.add(5);

aList.add(7);

aList.add(5);

aList.add(6);

for(int i=0;i<aList.size();i++){

for(int j=i+1;j<aList.size();j++)

{

//Check for duplicate value using if condition

//If you are comparing Integer then you could use "==" sign; if you have string values then user equals method instead of ==. 

if(aList.get(i)==(aList.get(j)))

{

//if values matched then remove the value from J index and back your J index to previous index J--

aList.remove(aList.get(j));

j--;

}

}

}

//Print your list without duplicate value.

System.out.println(aList);

}

}

How to optimize SQL query?

How to optimize SQL query?

• Use Indexes Properly.
• Only retrieve the data you really need.(prefer using where clause)
• Avoid the use of functions in where clause.
• Avoid using SQL subqueries or nested queries. Use JOINS instead.
• Avoid Wildcard characters at the beginning of the LIKE statement.

• 
  

When your mind and body don't allow to work, go outside and do whatever you want. A day when we were in the same situation. PC: @mandip_waan

When your mind and body don't allow to work, go outside and do whatever you want. A day when we were in the same situation. PC: @mandip_waan via Instagram