How to freeze panes in Excel?
Freezing the rows or columns while working in a long workbook can be really useful. For example, the top row contains the headers of the workbook and while entering data or analyzing it
Demos and Full Guide
What is Excel MOD function?
The MOD function returns the remainder after a number is divided by the divisor. The general syntax is: = MOD(number, divisor)
Demos and Full GuideThe Kotlin map collection
The map is an interface and a collection in Kotlin. Maps are used to hold the pairs of objects in the form of key/value.
Demos and Full GuideWhat is Kotlin lambda?
In Kotlin, you may define and use the lambda and anonymous function, that is called “function literals”.
Demos and Full Guide
What is list in Kotlin?
A list is a generic collection of elements. Kotlin has three Collections while List is one of those. The other two collections are Set and Map.
Demos and Full GuideWriting Kotlin Hello World program
The Kotlin code below simply displays the “Hello World” on the screen and this is followed by explaining code lines in that program:
Demos and Full Guide
How Kotlin while loop works?
In Kotlin, the while works just like in Java. So, if your background is Java then you already know how it works. For beginners, the while loops execute a block of code until the given condition is True.
Demos and Full Guide
What is an array in Kotlin?
The array class represents an array in Kotlin. Array class has get and set functions. The items in array are called elements.
Demos and Full Guide
How Kotlin if works?
Kotlin if is an expression that returns a value. This is different if compared with the other languages where if acts as a statement. As, it acts as an expression in Kotlin, so there is no ternary operators (condition ? then : else).
Demos and Full Guide
Kotlin when (replacement of switch statement)
In Kotlin, we have no switch statement. Instead, Kotlin replaces the switch with the When expression.
Demos and Full Guide
A few main points about Kotlin Range
In Kotlin, the ranges has the operator form .. (double dot). A Kotlin range can also be created by using the rangeTo() and downTo() function.
Demos and Full Guide
What is Kotlin for loop?
The for loop in Kotlin can be used to iterate through anything that provides an iterator. For example, a range, array, string, etc.
Demos and Full Guide
What is MySQL LEFT JOIN?
The LEFT JOIN combines two tables and returns the matched records from both tables and unmatched records from the “left” table as well.
Demos and Full Guide
What is DISTINCT clause in MySQL?
The DISTINCT clause in MySQL is used to fetch the unique records from the table. The DISTINCT is used with the SELECT statement and removes duplicate records from the record-set.
Demos and Full Guide
A few points about the MySQL LIKE operator
The LIKE operator is used to fetch the records from the table data with the pattern. The LIKE operator is generally used with wildcards; % and _ i.e. percentage and underscore.
Demos and Full Guide