COALESCE Function In Sql Server

Introduction:

During Development we have use more time Colesce method If someone have home address or office address suppose if you dispaly available first record means you can use coalesce method or concatinate columns we use this coding

FORMAT() Function in Sql Server

Introduction:

The FORMAT() function is used to format how a field is to be displayed.

NOW() Function in Sql Server

Introduction:

The NOW() function returns the current system date and time.

ROUND() Function in Sql Server

Introduction:

The ROUND() function is used to round a numeric field to the number of decimals specified.

LEN() Function in Sql Server

Introduction:

The LEN() function returns the length of the value in a text field.

MID() Function in sql server

Introduction:

The MID() function is used to extract characters from a text field.

LCASE() Function in sql server

Introduction:

The LCASE() function converts the value of a field to lowercase.

UCASE() Function in sql server

Introduction:

The UCASE() function converts the value of a field to uppercase.

SUM() Function in sql server

Introduction:

The SUM() function returns the total sum of a numeric column.

MIN() Function in sql server

Introduction:

The MIN() function returns the smallest value of the selected column.

MAX() Function in sql server

Introduction:

The MAX() function returns the largest value of the selected column.

Sysntax:

SELECT MAX(column_name) FROM table_name;

Example

SELECT MAX(Price) AS HighestPrice FROM table; 

Last() Function in sql server

Introduction:

The LAST() function returns the last value of the selected column.

How to Use the RANK Function in sql server

Introduction:

Sometimes you want a row that has the same order by column value as another row to have the same ranking.  If this is the case then the RANK() function will help you.  The RANK function has the following calling syntax:

First() Function

Introduction:

Returns the first value of the specified expression.

Count() Function

Introduction:

The count function returns the number of rows which are currently in existence.It is used when number of rows in the collection are unknown. This Count function oftenly used when you have large tables, or you expect a large output means you want to count total number of rows with you search condition like in where clause. In such situations, it is desirable to determine the number of rows of output that you will be getting before actually displaying the output. In this section, we introduce the COUNT function and we also take another look at the concept of null values.

AVG() Function

Introduction:

The avg function in sql server provide the mathematical average of a series of values. In other words we can say that The AVG function calculates the arithmetic mean (the sum of non null values divided by the number of non null values) of a set of values contained in a numeric column (or attribute) in the result set of a query.