Get data the way you want

SQL has a RAND function that can be invoked to produce random numbers between 0 and 1 − SQL>  SELECT RAND( ), RAND( ), RAND( ); +------------------+-----------------+------------------+ | RAND( )          | RAND(…

SQL SQRT function is used to find out the square root of any number. You can use a SELECT statement to find out the square root of any number as follows −…

SQL SUM function is used to find out the sum of a field in various records. To understand SUM function, consider an employee_tbl table, which is having the following records − SQL> SELECT * FROM employee_tbl;…

SQL AVG function is used to find out the average of a field in various records. To understand AVG function, consider an employee_tbl table, which is having the following records − SQL> SELECT * FROM employee_tbl;…

SQL MIN function is used to find out the record with the minimum value among a record set. To understand MIN function, consider an employee_tbl table, which is having the following records − SQL> SELECT *…

SQL MAX function is used to find out the record with the maximum value among a record set. To understand MAX function, consider an employee_tbl table, which is having the following records − SQL> SELECT *…

SQL COUNT function is the simplest function and very useful in counting the number of records, which are expected to be returned by a SELECT statement. To understand the COUNT function, consider an employee_tbl table, which…