Category: SQL Commands

SQL UPPER() function is used to convert character string from lower case to upper case. Syntax UPPER (CharacterString) Below is an example converting small letter character string to upper case. SELECT UPPER(‘sqlserverlog.com’) AS MyWebsite...

SQL RIGHT() function returns substring from right side of specified string from a given column. If any column cell contains NULL value then it returns output as NULL for that value. Syntax SELECT RIGHT...

SQL LEFT() function returns substring from left side of specified string from a given column. If any column cell contains NULL value then it returns output as NULL for that value. Syntax SELECT LEFT...

SQL CHECK constraint enforces a condition to check the value to be entered into a table. If you will define a CHECK constraint on a column then at the time of entering a record it evaluates that...

SQL AVG() function returns the average value of a numeric column of a table and it ignores NULL values during calculation. Syntax SELECT AVG(columnName) FROM TableName In this article we will consider Student table...

SQL COUNT() function returns the number of records from a table in a SELECT statement. Syntax SELECT COUNT (columnName) FROM TableName OR SELECT COUNT (*) FROM TableName Note: Count(*) will return all the records...