#sql functions

Mastering a new programming language might be scary. Like any other, it has a wide vocabulary that you must learn. But what better way to learn SQL than mastering the SQL functions? There are numerous SQL functions for working with various data types. Once you are all versed with some of the most common, you'll have enough confidence to go on to more challenging ones. Once you have mastered the fundamentals, consider digging further into these topics to expand on what you already know.

A Guide to SQL NULL (and SQL NOT NULL)

The concept of NULL is something you should know about when working with databases.

In this article, you’ll learn all about NULL: what it is, why it’s different, how you can check for it in different databases, and many examples.

(more…)

SQL Aggregate Functions | Queries with Aggregates

Sql Aggregate functions provide a way to find answer like “How many movies are directed by John Lasseter?”, or “Which movie has the highest sales?”  in movie database. This function is also helpful to summarise information about a group of rows of data.

Sql provides various aggregate functions. Here we will discuss few of them which are very common:

COUNT(col-name) – Returns the number of…

SQL string manipulation functions, SQL string manipulation functions are mainly used for string control. SQL gives us a lot of string manipulation functions that provides us the ability to manipulate string values.

SQL: User Defined Functions

Functions in SQL work just like functions in most programming languages. If you aren’t familiar with a function, you should know that you are already using them without even knowing it.

Consider this for example:

Select Count(*) From Table

COUNT() is a function. When you pass it rows from your query, it counts the rows and returns a value in the form of an integer. But COUNT() is a built in…

Oracle Built-in UPPER case function an example

UCASE or UPPER takes a character expression as a parameter and returns a string in which all alpha characters have been converted to uppercase. The syntax for UPPER case function as given in Oracle documents is as follows. Syntax UCASE or UPPER ( CharacterExpression ) If the parameter type is CHAR , the return type is CHAR. Otherwise, the return type is VARCHAR. Note: UPPER and LOWER follow the…

My grandparents had a small farm in Iowa . We only lived a few miles away and my brothers and I spent a great deal of time at the farm with our grandparents when we weren’t in school. I traded the rolling corn fields of Iowa for the rusty-reddish brown soil of Arizona many years ago, but I frequently think about my grandparents and working around the farm with the crops, the garden, the animals…