Adglob Infosystem Pvt Ltd

Apache Presto – Home

Post author:S K S
Post published:August 20, 2021
Post category:apache
Post comments:0 Comments

Apache Presto is an open source distributed SQL engine. Presto originated at Facebook for data analytics needs and later was open sourced. Now, Teradata joins Presto community and offers support.…

MySQLi – Insert Query

Post author:K Z
Post published:August 20, 2021
Post category:MySQLi
Post comments:0 Comments

To insert data into a MySQL table, you would need to use the SQL INSERT INTO command. You can insert data into the MySQL table by using the mysql> prompt or by…

T-SQL – Numeric Functions

Post author:B D
Post published:August 19, 2021
Post category:T-SQL
Post comments:0 Comments

MS SQL Server numeric functions can be applied to numeric data and will return numeric data. Following is the list of Numeric functions with examples. ABS() The absolute value will…

XPath – Expression

Post author:k A
Post published:August 19, 2021
Post category:XPath
Post comments:0 Comments

An XPath expression generally defines a pattern in order to select a set of nodes. These patterns are used by XSLT to perform transformations or by XPointer for addressing purpose.…

T-SQL – Date Functions

Post author:B D
Post published:August 19, 2021
Post category:T-SQL
Post comments:0 Comments

Following is the list of date functions in MS SQL Server. GETDATE() It will return the current date along with time. Syntax The syntax for the above function − GETDATE()…

XPath – Overview

Post author:k A
Post published:August 19, 2021
Post category:XPath
Post comments:2 Comments

XPath is a query language that is used for traversing through an XML document. It is used commonly to search particular elements or attributes with matching patterns. This tutorial explains…

T-SQL – String Functions

Post author:B D
Post published:August 19, 2021
Post category:T-SQL
Post comments:1 Comment

MS SQL Server String functions can be applied on string value or will return string value or numeric data. Following is the list of String functions with examples. ASCII() Ascii…

SQL – String Functions

Post author:B D
Post published:August 19, 2021
Post category:SQL T-SQL
Post comments:0 Comments

SQL string functions are used primarily for string manipulation. The following table details the important string functions − Sr.No.Function & Description1ASCII() Returns numeric value of left-most character2BIN() Returns a string…

SQL – Numeric Functions

Post author:B D
Post published:August 19, 2021
Post category:SQL T-SQL
Post comments:2 Comments

SQL numeric functions are used primarily for numeric manipulation and/or mathematical calculations. The following table details the numeric functions − Sr.No.Function & Description1ABS() Returns the absolute value of the numeric…

SQL – CONCAT Function

Post author:B D
Post published:August 19, 2021
Post category:SQL T-SQL
Post comments:0 Comments

SQL CONCAT function is used to concatenate two strings to form a single string. Try out the following example − SQL> SELECT CONCAT('FIRST ', 'SECOND'); +----------------------------+ | CONCAT('FIRST ', 'SECOND') | +----------------------------+…