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 Example | log10() in SQL
SQL log10 () function is used for returning the natural logarithm of a number to its base 10.
SQL log10
The LOG10() function in SQL returns the natural logarithm of a number to base 10.
Syntax
SELECT LOG10 (Number)
Parameters…
SQL PI Function Example | PI in SQL
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 Power Function Example | SQL power() Tutorial
SQL power() is an inbuilt function that is used to return the value of the specified expression to the specified power. SQL POWER function is used to return the value of the determined expression to the specified power. SQL POWER() method…
SQL DEGREES() Function Example
SQL DEGREES() is an inbuilt function that is used to convert a value from radians to degrees. Here, the angle (in radians) is provided as an input to the function and the function will return the value in degrees. The SQL DEGREES() function…
SQL Exp Function Example
SQL EXP() is an inbuilt function that is used for finding the exponent of a float_expression specified. The exponent of the number is the constant e raised to the power of the number. The base of natural logarithms is e (2.718281…), which…
What is Data Aggregation | Examples of Data Aggregation
Data aggregation is a process where raw data is gathered and expressed in the form of a summary for statistical analysis. Data aggregation may be done manually or through specialized software called automated data aggregation. For example,…
SQL CURRENT_TIME Function Example Tutorial
SQL CURRENT_TIME is an inbuilt function that is used for returning the current time of the database server. The time will be returned either as "HH-MM-SS" (string) or as HHMMSS.uuuuuu (numeric). SQL CURRENT_TIME() function returns the…
SQL GETUTCDATE Function Example Tutorial
SQL GETUTCDATE is an inbuilt function that is used for returning the current database date and time in UTC format, i.e. in a 'YYYY-MM-DD hh:mm:ss.mmm' format. The GETUTCDATE() function returns the current UTC. The GETUTCDATE() function…
SQL GETDATE Function Example
SQL GETDATE function is used to return the current system TIMESTAMP as a DATETIME value without the database time zone offset. The value is derived from the Operating System of the server on which the instance of SQL Server is running at…
SQL SYSDATETIME Function Example
SQL SYSDATETIME is an inbuilt function 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 SYSDATETIME() function has more fractional seconds…
SQL SOUNDEX Function Example Tutorial
SQL SOUNDEX is an inbuilt function that accepts the string and returns the phonetic expression, i.e., converts it into four-character code based on how the string sounds when spoken. The SOUNDEX() function returns the four-character code…