Azure, RPA, AI, Selenium, Angular, API
While loop in Java
import java.util.Scanner;
class WhileLoop {
public static void main(String[] args) {
int i;
Scanner input = new Scanner(System.in);
System.out.println(“Please input an integer value”);
while ((i = input.nextInt()) != 0) {
System.out.println(“You have entered ” + i);
System.out.println(“Please input an integer value”);
}
System.out.println(“Gone out of loop”);
}
}
How to implement Multiplication program in java:
import java.util.Scanner;
class TableForMultiplication
{
public static void main(String args[])
{
int i, j;
System.out.println(“Enter an integer to display it’s multiplication table…”);
Scanner in = new Scanner(System.in);
i = in.nextInt();
System.out.println(“Multiplication table of “+i+” is :-“);
for ( j = 1 ; j <= 10 ; j++ )
System.out.println(i+”*”+j+” = “+(i*j));
}
}
AND, OR, and NOT operators are combined with the WHERE clause to get the desired filtered results.
e.g SELECT * FROM Users
WHERE State =’illinois’ AND City=’Chicago’;
e.g SELECT * FROM Users
WHERE City=’Chicago’ OR City=’New York’;
e.g SELECT * FROM Users
WHERE NOT State =’Chicago’;
SQL WHERE clause is used to filter records and its added as below
SELECT States FROM Users where Usersgroup = ‘1’;
import java.util.Scanner;
class TestingBreakWhileLoop {
public static void main(String[] args) {
int i;
Scanner input = new Scanner(System.in);
while (true) {
System.out.println(“Input an integer for this test program”);
i = input.nextInt();
if (i == 0) {
break;
}
System.out.println(“You have entered … ” + i);
}
}
}
The purpose of ORDER BY keyword is used to sort the results in descending or ascending order
e.g SELECT * FROM Users
ORDER BY State DESC;
e.g SELECT * FROM Users
ORDER BY State ASC;
or
SELECT * FROM Users
ORDER BY State;
SELECT DISTINCT statement is used for returning only distinct (different) values from a column.
SELECT statement is used for returning all the values in the table column.
E.g SELECT States FROM Customers;
E.g SELECT DISTINCT States FROM Customers;
// Use join() method to join the elements of the array into a string as below in comments
var joinArray = arrayReverse .join(“”); // [“e”, “m”, “o”, “c”, “l”, “e”, “w”] to “emoclew”
//Return the reversed string
return joinArray; // “emoclew”
}
stringRev(‘welcome’);