Showing posts from December, 2011
SQL

SQL LCASE( ) Function

The LCASE() function converts the value of a field to lowercase. SQL LCASE() Syntax SELECT LCASE(column_name) FROM table…

SQL

SQL UCASE( ) Function

The UCASE() function converts the value of a field to uppercase. SQL UCASE() Syntax SELECT UCASE(column_name)  FROM ta…

SQL

SQL HAVING Clause

The HAVING Clause The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions. …

SQL

SQL GROUP BY Statement

Aggregate functions often need an added GROUP BY statement. The GROUP BY Statement The GROUP BY statement is used in conjun…

Load More That is All