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 »
SQL is a database language that is used to create, delete and manipulate databases. SQL stands for Structured Query Language. It supports Relational databases. Dialects of SQL: Microsoft SQL Server using SQL as T-SQL Oracle using SQL as PL/SQL Microsoft Access using as SQL as JET SQL Advantages of SQL: Access data of any relational …
SQL Introduction- Free Tutorial and Online Training Read More »