AppDividend
Latest Code Tutorials
Browsing Category

SQL

SQL is a standard language for storing, manipulating and retrieving data in databases.

Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

SQL Log10 Function: Complete Guide

SQL log10 () function is used for returning the natural logarithm of a number to its base 10. SQL log10 The LOG10() is a built-in SQL function that returns the natural logarithm of a number to base 10. Syntax SELECT LOG10 (Number)…

SQL CURRENT_TIME(): Complete Guide

The CURRENT_TIME is a standard-SQL function supported by almost all database systems such as DB2, Firebird, MySQL, PostgreSQL, and SQLite. SQL Server does not support the CURRENT_TIME function; however, you can use the GET_DATE() function…

SQL ABS() Function: Complete Guide

SQL ABS() function returns the absolute value of a number when passed as an argument, i.e., the negative number gets converted to an absolute positive number. SQL ABS() SQL ABS() is a built-in method is used to get the absolute value of…

SQL STR() Function: Complete Overview

The STR() function returns the number as a string. If there is not enough length or decimal to display the resulting string based on the parameters provided, the function will round off the result. SQL STR() SQL STR() is a built-in…

SQL PI Function: The Complete Guide

SQL PI function is used for returning the mathematical value of the constant π (pie). The PI() function returns the value of PI. SQL PI PI is a mathematical constant number to represent the ratio of a circle’s circumference to its…

SQL CONVERT Function: Complete Guide

SQL CONVERT() function converts the value (of any type) into a specified datatype. SQL CONVERT SQL CONVERT() is a built-in function that is used for converting an expression from one data type to another data type. Here, if the…