You are here
Home > Author: Riya Patel (Page 2)

SQL: Aggregate Functions

SQL: Aggregate Functions In this post we will discuss aggregate functions. T-SQL support SUM, MIN, MAX, AVG, COUNT, SQRT, POWER and other aggregate functions. It ignores NULL inputs when applied to an expression. Use DISTINCT clause to remove duplicate values. In the group query the aggregate functions is applied per group,

SQL:Logical Functions

Logical Functions In this post we will discuss logical functions like IIF, CHOOSE, ISNUMERIC. The output of these functions are determine by comparative logic. These functions simplify migrations from Microsoft access platforms and it is nonstandard T-SQL functions. IIF() IIF() returns one of two values, depending on whether the boolean expression evaluates

SQL 70-761 Quiz

Welcome to SQL quiz. we have list of questions and there is no time limit for giving the answer. this quiz improve your SQL and database knowledge.We have divided SQL quiz into three parts. Keep Visiting for more upcoming top technical articles and also see my new blog Mag4info. and for kotlin tutorial also

Kotlin Secondary Constructor

Kotlin Secondary Constructor In previous post we discussed kotlin classes and primary constructor. And in this post we will discuss how to defined secondary constructor in kotlin classes. Kotlin Secondary Constructor For declaration of secondary constructor use constructor keyword: class Employee {                        constructor(parent: Employee) { parent.children.add(this) } } If the class has a primary constructor, each secondary constructor

Deterministic & Non-deterministic Functions

Deterministic & Non-deterministic Functions In this post we will discuss about Function determinism. Function can be deterministic or non-deterministic. Function determinism is a characteristic that indicates whether the function is guaranteed to return the same result given the same set of input values in different invocations. If the function provides such

SQL: Case Expression

CASE EXPRESSION In this post we will discuss CASE statement. This statement performs some kind of an action or controls the flow of the code. The CASE expression has two forms- the simple form and the searched form. CASE returns a value, and hence is an expression. Simple CASE The simple form