Azure, RPA, AI, Selenium, Angular, API
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’);
Low Severity and Low Priority: A cosmetic error in a page which is not important to users.
High Severity and High Priority: An error in the login feature which does not allow user to login to application or a server error in the web application.
Low Severity and High Priority : The spelling mistakes that happens on the cover page or heading or title of an application.
High Severity and Low Priority: A page access error which page is rarely used by users.