- Not a Triangle: Node1 > Node2 > Node3 > Node10
- Equilateral Triangle: Node1 > Node2 > Node4 > Node5 > Node10
- Isosceles Triangle: Node1 > Node2 > Node4 > Node6 > Node7 > Node10
- Scalene Triangle: Node1 > Node2 > Node4 > Node6 > Node8 > Node9 > Node10
Sunday, January 10, 2021
Path Testing in Software Testing with Example | Triangle Problem
Sunday, January 3, 2021
SQL Queries Tutorial | Sql Query tutorial for Beginners with Examples
select * from Customers
select CustomerID, CustomerName, Country from Customers
select top 5 CustomerID, CustomerName, Country from Customers
5) [SQL for beginners] Select all fields of all records from the Employees table.
select * from Employees
select * from Employees order by FirstName
select * from Employees order by FirstName desc
8) Select OrderID field with alias ID, CustomerID field with alias Customer and so on from the Orders table.
select OrderID as ID, CustomerID as Customer, OrderDate as [Date] from Orders
select Orders.OrderID, Customers.CustomerName, Customers.Country
from Orders inner join Customers on Orders.CustomerID = Customers.CustomerID
10) Select those Employees whose EmployeeID does not appear in the Orders table.
select * from Employees where EmployeeID not in (select EmployeeID from Orders)
select Employees.FirstName, Employees.LastName, Orders.OrderID
from Employees left join Orders on Employees.EmployeeID =Orders.EmployeeID
order by Employees.FirstName, Employees.LastName
12) [SQL Joins] Select with Right Join of Orders table with Employees table.
select Employees.FirstName, Employees.LastName, Orders.OrderID
from Orders right join Employees
on Employees.EmployeeID =Orders.EmployeeID
order by Employees.FirstName, Employees.LastName
13) [SQL Joins] Select pairs of products with the same price using Self Join of Products table.
select P1.ProductID as ID1, P1.ProductName as Name1, P1.Price as Price1, P2.ProductID as ID2, P2.ProductName as Name2, P2.Price as Price2
from Products P1 inner join Products P2 on P1.Price = P2.Price and P1.ProductID <> P2.ProductID
14) [SQL queries examples] Using Union, select Country field values from the Customers table and Suppliers table.
select Country from Customers union all select Country from Suppliers
16) Using Group By, count the total number of suppliers per country from the Suppliers table.
select count(SupplierID) as TotalSuppliers, Country
from Suppliers group by Country
17) Using Group By, count the total number of products per price point from the Products table.
select count(ProductID) as ProductsNumber, Price
from Products group by Price order by Price
18) Using the above SQL query, select only those price points that have more than one product.
select count(ProductID) as ProductsNumber, Price
from Products group by Price having count(ProductID)>1 order by Price
19) Using a sub query, select those customers who have ordered any quantity more than 90 units.
select CustomerID, CustomerName from Customers
Sunday, December 20, 2020
SelectorsHub Introduction | SelectorsHub tutorial for CSS selectors and XPath locators
This post introduces SelectorsHub, which is a free tool to find correct CSS selectors and XPath locators automatically. CSS selectors and XPath locators can be tough to write for beginners in test automation, like those learning Selenium WebDriver automated testing, or take time to write for experienced web developers and test automators. SelectorsHub automatically suggests complete selectors like CSS selectors, XPath and other web element locators. View SelectorsHub demonstration to find CSS selector like CSS Id and Css Class Selector or read on.
View SelectorsHub demonstration on how to find XPath in Chrome Browser and how to find XPath in Firefox. SelectorsHub is also available for Edge and Opera browsers.
SelectorsHub may help you improve XPath and CSS selectors writing skills. It offers choices of selectors and locators with the number of occurrences of each. SelectorsHub works with shadow DOM and svg element. It also gives the error message if case of any mistake in your written selector. SelectorsHub's user interface may be customized, if you want. View the demonstration of SelectorsHub features and benefits.
For details, check out What is SelectorsHub. You may also contact Sanjay Kumar, the inventor of SelectorsHub. Thank you.