Find nth highest Salary in database

SELECT FROM Student stud1
WHERE (N-1) = (SELECT COUNT(DISTINCT(stud2.rank))
FROM Student stud2
WHERE stud2.rank > stud1.rank)

Program to Read String xml data in java

    String url ="<start><firstelement><displayname>username</displayname><name>username</name></firstelement><secondelement><displayname>password</displayname><name>password</name></secondelement></end>";
    String displayname[] = StringUtils.substringsBetween(url,"<firstelement>","</firstdelement>");

    for(int x=0;x<displayname.length;x++){
        String dname = StringUtils.substringBetween(displayname[x],"<name>","</name>");
        System.out.println("dname==>> "+dname);//This will print username and password   
}

=> If you want to fetch different tags data just change the tags name in the substringsBetween() method.

Find Second Highest Number

public class FindSecondHighestNumber {

    public static void main(String[] args) {

        int num[] = {72,91,91,4,6,10,72,31};
        int n = num[0];
        int n1 = 0;
        for(int i = 0;i<num.length;i++){
            if(n<=num[i]){
            if(n<num[i]){
                n1 = n;
                n = num[i];
             }
            }else if(n1<num[i])
                n1 = num[i];
        }
    System.out.println("high=> "+n+" sendhigh=> "+n1);
    }

}

How to find close to 100 number

public class CloseTo100 {

    public static int findNearestNumbers(int in1,int in2){

    int in1Diff =    Math.abs(100-in1);
    int in2Diff =    Math.abs(100-in2);
if(in1Diff<in2Diff){
    return in1;
}else if(in1Diff>in2Diff){
    return in2;
}else{
    return in1;
}
    }
    public static void main(String[] args) {
System.out.println(CloseTo100.findNearestNumbers(95, 104));
    }

}