Category: SQL Tutorials

SQL MID() and SQL-Server SUBSTRING() Function MID() – The MID() function is used to return exact text from given text field. The syntax of MID()…

SQL LCASE() and SQL-Server LOWER() Function SQL LCASE() and SQL Server LOWER() both function used to convert text to lowercase and return it. In SQL…

SQL UCASE() and SQL-Server UPPER() Function SQL UCASE() and SQL Server UPPER() both function used to convert text to uppercase and return it. In SQL…

SQL NOW() and SQL-Server GETDATE() Function NOW() – The sql function NOW() is returns current system date and time. The sql syntax of NOW() is…

SQL ROUND() Function ROUND() – The ROUND() function used to rounds the value and returns it. The syntax of ROUND() is: SELECT ROUND(col_name, decimal) FROM…

SQL LEN() Function LEN() – The LEN() function used to returns the length of text field. The syntax of LEN() is : SELECT LEN(col_name) FROM…

SQL Aggregate Functions In this post we will learn basic functions in sql and explain how to use functions with an example. SQL has many…

SQL Scalar functions In this post we will learn basic functions in sql and explain how to use functions with an example. SQL has many…

SQL AND & OR Operators The AND and OR Operator are used to returns records match with more than one condition in WHERE condition. The…

SQL BETWEEN Operator SQL BETWEEN Operator  – The SQL BETWEEN operator is used to returns records match between two values in WHERE  Condition. The range of value…

SQL IN Operator SQL IN Operator – The SQL IN operator used to select column with more than one value in WHERE condition. The IN operator…

SQL LIKE Operator SQL LIKE Operator – The SQL LIKE operator is used to returns all rows from a table whose column value match a…