sql data types

LCASE Function in SQL This string function shows all the string characters in the lower case in Structured Query Language. It converts…

UCASE Function in SQL This string function shows all the string characters in the upper case in Structured Query Language. It converts…

RPAD Function in SQL This string function adds the symbol or the string to the right side of the original string. In…

LPAD Function in SQL This string function adds the symbol or the string to the left side of the original string. In…

SQL IN Operator IN is an operator in SQL, which is generally used with a WHERE clause. Using the IN operator, multiple…

Check Constraint in SQL Check constraint is validation or a rule which is applied on the column of a table. When we…

Types of SQL JOIN SQL JOIN A SQL Join is used to fetch or combine data (rows or columns) from two or…

SQL INDEX The Index in SQL is a special table used to speed up the searching of the data in the database…

TRUNCATE Function in SQL The TRUNCATE is a numeric function in SQL which truncates the number according to the particular decimal points.…