SQL Aggregate functions are described in this article. SQL functions are like average , sum , count , first last etc. SQL Aggregate functions Consider the following Student table with ID, Marks, Age,Name as columns. +—-+——-+—–+———–+ | Table Name – Student | +—-+——-+—–+———–+ | ID | MARKS | AGE | NAME | +—-+——-+—–+———–+ | 1 …
SQL Aggregate Functions – Free Tutorial and Online Training Read More »
In SQL, there are a lot of library functions used while working with Date in Databases. The given below are the list of SQL date functions along with examples. SQL Date Functions NOW(): NOW() function returns the current date and time of the system. Example: Query: Select NOW (); Result: 2018-14-21 15:08:05 CURDATE(): CURDATE() functions …
SQL Date Functions – Free Tutorial and Online Training Read More »
In SQL, there are various data types for string like VARCHAR, CHAR, RAW, VARCHAR2 etc. But, when the SQL character functions are used, the output data type is VARCHAR2. SQL Character functions It can be broadly classified into two categories: Case Manipulation functions Character Manipulation functions Case Manipulation Functions in SQL : LOWER(): LOWER() returns …
SQL Character Functions – Free Tutorial and Online Training Read More »
In SQL Server, there are a lot of library functions. This article describes the use of several Mathematical functions with examples. SQRT(): SQRT () function is commonly used in SQL and takes numeric value & gives square root of that number as output Example: Query: Select SQRT (100); Result: 10 Query: Select SQRT (169); Result: …
SQL Server Mathematical Functions – Free Tutorial and Online Training Read More »
Operators are used in SQL to perform comparisons, and also to apply conditions in the query. Often SQL operators are also used to join conditions used in the query. The following types of SQL operators are present in SQL Arithmetic operators Logical operators Comparison operators Operations used for negation Arithmetic Operators in SQL: Let us …
SQL Operators – Free Tutorial and Online Training Read More »