Tag: SQL

We will consider in detail the process of installing the free edition of MySQL 8 Community on the Windows 10 operating system. What is MySQL? MySQL is a free relational database management...

Oracle/PLSQL MOD function returns the residue from division m by n. Oracle/PLSQL syntax of the MOD function MOD( m, n ) Parameters and function argumentsMOD is calculated as: m - n *...

The Oracle/PLSQL MIN function returns the minimum value of the expression. Oracle/PLSQL syntax of MIN function SELECT MIN(aggregate_expression_id) FROM tabs [WHERE conds]OR syntax for MIN...

The Oracle/PLSQL MEDIAN function returns the expression median. Oracle/PLSQL syntax of MEDIAN function MEDIAN( expression_id ) [ OVER ( query partition clause ) ] Parameters and function...

The Oracle/PLSQL MAX function returns the maximum value of the expression. Oracle/PLSQL syntax of the MAX function SELECT MAX(aggregate_expression_id) FROM tabs [WHERE conds]OR syntax for...

The Oracle/PLSQL LOG function returns the logarithm n at the base m. Syntax of the Oracle/PLSQL LOG function LOG( m, n ) Parameters and argumentsm must be a positive number, except 0 or...

Oracle/PLSQL LEAST function returns the smallest value in the expression list. Oracle/PLSQL syntax of the LEAST function LEAST( expr1_id, expr2_id, ... expr_n_id ) Parameters and function...

Oracle/PLSQL GREATEST function returns the highest value in the list of expressions. Oracle/PLSQL syntax of the GREATEST function GREATEST( expr1_id, expr2_id, ... expr_n_id ) Parameters and...

The Oracle/PLSQL FLOOR function returns the largest integer value equal to or less than a number. Oracle/PLSQL syntax of the FLOOR function FLOOR( number_id ) Parameters and function...

We will take a closer look at how to install PostgreSQL 11 on Windows, you will learn where to download PostgreSQL 11 for Windows, how the installation process looks like and how to connect to...

There are official ratings and other analytical data that show DBMS popularity.Some ratings are based on the frequency of reference in search engine queries, ie, if people are more often looking...

The Oracle/PLSQL ACOS function returns the number arcosine. Oracle/PLSQL syntax of the ACOS function ACOS( number_id ) Parameters and function argumentsnumber_id - number to calculate...

Oracle/PLSQL EXP function returns e elevated to n-th degree where e = 2.71828183. Oracle/PLSQL syntax of the EXP function exp( number_id ) Parameters and function argumentsnumber_id -...

The Oracle/PLSQL COUNT function  returns the number of rows returned by the query. Oracle/PLSQL syntax of COUNT function SELECT COUNT(aggregate_expression_id) FROM tabs [WHERE conds]OR...

The Oracle/PLSQL CEIL function returns the smallest integer number that is greater than or equal to number. Oracle/PLSQL syntax of CEIL function CEIL( number_id ) Parameters and function...

The Oracle/PLSQL BITAND function returns an integer number representing the bitwise operation AND over the bits expr1 and expr2. Oracle/PLSQL syntax of the BITAND function bitand( expr1_id,...