RDBMS – RDBMS full form is Relational Database Management Systems. It forms the basis for SQL, DB2, Oracle etc. It is based on the relational model defined by E.F.Codd Table in SQL In RDBMS, the organization of data is in the form of tables. A table is a collection of related data entities and is an …
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 »