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 SYSUTCDATETIME Function Example
SQL SYSUTCDATETIME() is an inbuilt Date function that is used to return the Current Date and Time of the system i.e., DATETIME2 on which the SQL Server instance is running. The DATETIME is in coordinated Universal Time (UTC). The format is:…
SQL COS() Function Example | COS() in SQL
SQL COS() is an inbuilt function that is used for finding the cosine of a specified angle – measured in radians – in the determined expression. The COS() function in SQL returns the cosine of a number.SQL COS()
SQL COS() function…
SQL COT() Function Example | COT() in SQL
SQL COT() is an inbuilt function that is used for finding the cotangent the specified angle – in radians – in the specified float expression. MySQL COT() returns the cotangent of a number. A number whose cotangent value is to be retrieved.…
SQL RADIANS() Function Example | RADIANS() in SQL
SQL RADIANS() is an inbuilt function that is used for converting the angle in the degree to approximate angle measured in radians. SQL ROUND() function rounds the number to a particular number of decimal places. It returns a numeric value,…
SQL ROUND Function Example | ROUND() in SQL
SQL ROUND() function is used for rounding a number to a specific decimal place. Here, the user provides the number as an argument, as well as the length for rounding the number. The function also accepts the optional third argument that…
SQL SIGN() Function Example | SIGN() in SQL
SQL SIGN() is an inbuilt function that is used for returning the sign of the number. It indicates whether the number is positive or negative by returning the following result: -1 if the number is positive i.e. number>0
-1 if…
SQL SIN() Function Example | SIN() in SQL
SQL SIN() is an inbuilt function that is used for finding the sine of a specified angle – measured in radians – in the specified expression.SQL SIN()
SQL SIN() is an inbuilt function that returns the sine of a number. More…
SQL SQRT() Function Example | SQRT() in SQL
SQL SQRT() is an inbuilt function that is used for returning the square value of the specified number. SQL SQRT() returns the square root of a given value in the argument. An expression is a numeric value or numeric data type. All of the…
SQL TAN Function Example | TAN() in SQL
SQL TAN() is an inbuilt function that is used for finding the tangent of the specified angle(in radians) in the defined float expression. The mathematical formula for this function is TAN(x) = Length of the Opposite Side / Length of the…
SQL CEILING Function Example | CEILING() in SQL
SQL CEILING() is an inbuilt function that is used for returning the smallest integer value that is greater than or equal to a number given as input. The ceiling() function returns the smallest integer value that is greater than or equal to…
SQL Floor Function Example | Floor() in SQL
SQL FLOOR() is an inbuilt function that is used for returning the smallest integer value that is smaller than or equal to a number given as input. The FLOOR() function returns the largest integer value that is smaller than or equal to a…