by S-Square | Sep 10, 2019 | Blogs
The Like operator is used to search the pattern in one table. Similarly, we can use the like operator along with the concatenation function to do a pattern matching between the multiple tables. Here I have given example for two tables. Examples: Here I have created...
by S-Square | Jul 30, 2019 | Blogs
Rank (): RANK function is used to rank the repeating values in a manner such that similar values are ranked the same. In other words, rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks...
by S-Square | Jun 26, 2019 | Blogs
JOINS: Join is used to combine one or more tables, from tables based on condition (Common fields). Joins are divided into four categories. Inner Join Left Outer Join Right Outer Join Full Outer Join Table A and Table B, with some sort of relation specified by primary...